Simple Data Normalization in Power Query using Transformation Techniques
Based on Recent Question from one of the Subscribers , Created a quick video to show how to Normalize complex Excel Data so that , you can use that data into a quick report.
The CurrentMonth function in Excel!? This custom function using LAMBDA will a quick help to get summary. Stay tuned for a full tutorial and even an Excel file to follow along with. #excel #lambda http