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 All I need to create a measure Month by YTD
This is my mesare
Measure 4 = CALCULATE(SUM(Rpl_SELL[TURNOVER]),ALLSELECTED(Rpl_SELL[MONTH],Rpl_SELL[YEAR]))
I want to divide the month (the red one) to Current YTD(the blue one)
Solved! Go to Solution.
Hi,
I found the solution.
TurnoverYD = CALCULATE(SUM(Rpl_SELL[TURNOVER]), ALL(Rpl_SELL[DATE].[Year],Rpl_SELL[DATE].[Month],Rpl_Satis_Flow_Unisel[DATE].[Day]))
This one is working on my dashboard
@sinanalmac , You can get it using the date table and get measure like
example
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
or
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"3/31"))
and then try
hi @amitchandak
thank you for your help
But with your measure, I Get the same result
Best regards
Sinan
Hi,
I found the solution.
TurnoverYD = CALCULATE(SUM(Rpl_SELL[TURNOVER]), ALL(Rpl_SELL[DATE].[Year],Rpl_SELL[DATE].[Month],Rpl_Satis_Flow_Unisel[DATE].[Day]))
This one is working on my dashboard
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
86 | |
85 | |
68 | |
66 | |
64 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |