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 want to show current month sales, last month sales, average of last 3 months, average of last 6 months, last year same month sales in a matrix. also i want to do it through a date range like 1 to 6 or 1 to 31.
i have seperate date table and that is mapped with my main sales file.
Solved! Go to Solution.
DateADD for last month
averagex and dateadd for other two options
sameperiod last year for last requirement
These dax will help you!
Just asking plain text will not help people to help you! you need to do some ground work before asking question in this forum
Proud to be a Super User!
DateADD for last month
averagex and dateadd for other two options
sameperiod last year for last requirement
These dax will help you!
Just asking plain text will not help people to help you! you need to do some ground work before asking question in this forum
Proud to be a Super User!
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.
User | Count |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |