Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a raw data file containing list of orders per customer and the date of delivery.
In the Pivot, I want to show the current total sales revenue per customer based on the selected months in the Timeline tool (i.e., May 2022 to April 2023) and also display the total from the previous year (i.e., May 2021 to April 2022) in the column next to the current year data. Additionally, I want to show the difference between the current year and last year sales. Ideally, the resulting Pivot Table looks like this if May 2022 to Apr 2023 is selected in Timeline tool:
Customer | Current Year | Previous Year | Difference |
A | 1,000 | 750 | 250 |
B | 640 | 900 | (260) |
I am quite familiar with M language but I may need a more thorough explanation since I am still basically a novice. Thank you for the assistance!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.