Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I am trying to calculate a moving 90 day sum that I am then plotting on a graph with the actual months (think June has June, May & April data, May has March, April, and May data etc). My data set is cost data for each product for each month with a number of other measures. I have been attempting this through various versions of the "Calculate(,FILTER( or Calculate(,DatesBetween(" functions with no luck. Has anyone done this before? I also tried calculating a number of custom columns where I would sum the previous month and the month before and add the columns together but that did not work either.
Solved! Go to Solution.
This should be close and works for me. This calculated measure assumes a relationship between the Sales and Dates tables.
Measure = CALCULATE( SUM('Sales'[Sales Qty]), ------------------------------------------------------------------------- DATESINPERIOD('Dates'[Date],LASTDATE('Dates'[Date]),-90,DAY) )
This should be close and works for me. This calculated measure assumes a relationship between the Sales and Dates tables.
Measure = CALCULATE( SUM('Sales'[Sales Qty]), ------------------------------------------------------------------------- DATESINPERIOD('Dates'[Date],LASTDATE('Dates'[Date]),-90,DAY) )
That looks to have worked! Thanks Phil!
User | Count |
---|---|
86 | |
83 | |
67 | |
61 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
84 | |
70 |