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.
I have measure
Solved! Go to Solution.
Hi @Analitika ,
Please try to create measure like this:
Measure 2 = var max_year = CALCULATE(MAX(financials[Year]),ALLSELECTED(financials))
return CALCULATE([Measure],FILTER(DATESYTD('Table'[Date]),max_year=YEAR('Table'[Date])))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Analitika ,
Please try to create measure like this:
Measure 2 = var max_year = CALCULATE(MAX(financials[Year]),ALLSELECTED(financials))
return CALCULATE([Measure],FILTER(DATESYTD('Table'[Date]),max_year=YEAR('Table'[Date])))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.