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 Guys,
So, I have a measure that does a cumulative sum, it is all good if I put this on the "datekey" level.
Since I will never see it on a date level, I want to move it to a year-month level so the calculation can run faster.
CumSum:=CALCULATE([Sales],FILTER(ALL(DimDate[YearMonthNumber]),DimDate[YearMonthNumber]<=MAX(DimDate[YearMonthNumber])))
YearMonthNumber = 201708
This works just fine using the YearMonthNumber as Axis, but if I would like to use this formula to be able to provide the same results if the axis is YearMonth
YearMonth = 2017-Ago
If I substitute from YearMonthNumber to YearMonth on the formula it wont work since its not numerical.
Any work around on this ? Hierarchys ?
Thanks!
Solved! Go to Solution.
Hi @Anonymous,
Can you share some sample data to analysis?
In addition, you can try to use below formula to transfer the string date to number date, then use it as the filter parameter.
CumSum:= var selectitem=CALCULATE(MAX('DimDate'[YearMonthNumber]),ALLSELECTED('DimDate'[YearMonth])) return CALCULATE([Sales],FILTER(ALL(DimDate),DimDate[YearMonthNumber]<=selectitem))
Regards,
Xiaoxin Sheng
Hi @Anonymous,
Can you share some sample data to analysis?
In addition, you can try to use below formula to transfer the string date to number date, then use it as the filter parameter.
CumSum:= var selectitem=CALCULATE(MAX('DimDate'[YearMonthNumber]),ALLSELECTED('DimDate'[YearMonth])) return CALCULATE([Sales],FILTER(ALL(DimDate),DimDate[YearMonthNumber]<=selectitem))
Regards,
Xiaoxin Sheng
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
172 | |
108 | |
105 | |
71 | |
70 |