Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Please could you help guiding me on this?
At the moment I have:
Total Incidents is DISTINCTCOUNT of report ID
Month Name and FY are from the calendar table
How do I make this line graph to appear incrementally for each year?
Aug = Aug count
Sep = Aug + Sep counts
Oct = Aug + Sep + Oct counts
...
Please please, thank you very much
Tried TOTALYTD but I don't quite understand, however I came up with the below but I would like to have the Measure reset in Aug each year
Please thank you
Oh, if you want it to reset within a specific partition, check out the WINDOW function. https://learn.microsoft.com/en-us/dax/window-function-dax
Example 2 should be quite useful:
RunningSum = SUMX ( WINDOW ( 1, ABS, 0, REL, ALLSELECTED ( 'Date'[Fiscal Year], 'Date'[Month Number Of Year] ), PARTITIONBY ( 'Date'[Fiscal Year] ) ), [Total Sales] )
Thank you for your help and suggestion, I ended up using:
Thank you very much for your patience, my DAX knowledge is <0.
I will keep researching.
Thanks again
I think you're looking for a cumulative sum. Try using the TOTALYTD function
thank you, I will look at this function
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
62 | |
51 | |
47 |
User | Count |
---|---|
213 | |
81 | |
64 | |
60 | |
56 |