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 |
---|---|
87 | |
85 | |
73 | |
69 | |
65 |
User | Count |
---|---|
214 | |
124 | |
117 | |
82 | |
76 |