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.
This has stumped me for hours now. My company runs on a 445 fiscal calendar and I cannot get my monthly rolling sum to continue based on date because my fiscal months are 445. In other words, each month begins 3/4 of the way through the month prior. For example, the fiscal month of September started on August 22nd and will end on September 25th.
What can I do to get a rolling sum that begins on the first day of the fiscal month and continues to the end of the fiscal month ignoring the actual date changes from one calendar month to the next? See sample data below:
Solved! Go to Solution.
Hi @SUBL ,
Can you create a fiscal date column and calculate ROLLING SUM based on this column?
Best Regards,
Jay
I'm still struggling with this. Anyone have a magic DAX expression or a couple lines of M-language to write a custom solution?
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 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |