Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Looking for help on syntax to use the Year function in set analysis. How do I need to modify the expression below to make it work?
=Sum({$<Year([Date Field])={2020}>}[Measure])
Hi @AJ2024 ,
Do you have a Year field based on the date in your datamodel?
Then use
Based on a date DD-MM-YYYY you could use
Make it dynamic, select the max value of YEAR
Last Year
Hi @AJ2024 ,
Do you have a Year field based on the date in your datamodel?
Then use
Based on a date DD-MM-YYYY you could use
Make it dynamic, select the max value of YEAR
Last Year
I don't have a year field in the data model currently but that sounds like the better solution. I'll go ahead and add it. Thanks!