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.
Hi,
I have written PREVIOUSMONTH() in below measure:
which you can see is incorrent, but when I add Year from my calendar, then year wise and monthwise it is showing correct result like below:
So, why it is hapenning here? actually I don't want to use Year column in my table and want the correct result, but it is showing wrong when I remove Year column from table.
Solved! Go to Solution.
Hi,
I got the solution here By @amitchandak
(1) Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, YOY - YouTube
I have used below DAX and it works fine for me.
Previous Month Sales = CALCULATE ( SUM ( Orders [Sales] ), OFFSET (- 1 , ALLSELECTED ( 'Orders' [Month Name] , Orders [Month Num] ), ORDERBY ( 'Orders' [Month Num] , ASC ), KEEP ) )
Great Help
Thank you,
Sandip Ghosh
in that case you need new features OFFSET
Hi,
I don't understand it, can you please give me the syntax or modified DAX what I was using?
Hi,
I got the solution here By @amitchandak
(1) Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, YOY - YouTube
I have used below DAX and it works fine for me.
Previous Month Sales = CALCULATE ( SUM ( Orders [Sales] ), OFFSET (- 1 , ALLSELECTED ( 'Orders' [Month Name] , Orders [Month Num] ), ORDERBY ( 'Orders' [Month Num] , ASC ), KEEP ) )
Great Help
Thank you,
Sandip Ghosh
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 |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |