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.
Hi there,
How would do a quick measure for year-to-date but make it such that it only starts cumulating from a certain month?
Solved! Go to Solution.
Hi @Topographical,
Quick measure doesn't provide feature to customize start month. You need to create a measure below (YTD only calculate after or on April):
YTDStartFromApril = TOTALYTD(SUM(Table2[Amount]),'Table2'[Date],FILTER(ALL('Table2'),'Table2'[Date]>=DATE(2017,4,1)))
Best Regards,
Qiuyun Yu
Hi @Topographical,
Quick measure doesn't provide feature to customize start month. You need to create a measure below (YTD only calculate after or on April):
YTDStartFromApril = TOTALYTD(SUM(Table2[Amount]),'Table2'[Date],FILTER(ALL('Table2'),'Table2'[Date]>=DATE(2017,4,1)))
Best Regards,
Qiuyun Yu
User | Count |
---|---|
82 | |
76 | |
71 | |
69 | |
54 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |