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 matrix visual which is having the combination of the FY, YTD ,MTD measures . The FY sales data should be whole year data regardless of the what you select in the slicer values (Year, Month)
FY Sales = CALCULATE (Sales, DATESYTD(ftcalendar[Date],"12/31")) - This should be constant value regardless of the Year, Month selection. This is not giving exact results. What is the best calucation for FY and previous financail year calucation measures.
Solved! Go to Solution.
I found the solution. FY Sales = TOTALYTD=(SALES, ENDOFYEAR(CALENDARDATE))
You could apply an ALL filter to the measures so they are not affected by the slicers you've mentioned.
I tried this option however it is not working
I found the solution. FY Sales = TOTALYTD=(SALES, ENDOFYEAR(CALENDARDATE))
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |