So I want to dynamically choose two years I want to compare for a measure, in my case - profit.I made a DAX measure to calculate profit for A year, for example:
Profit LY = CALCULATE([Profit]; Year[Year] = 2018 )
but I want to calculate the profit for a year I pick via a slicer. Is that achievable?
Hi. It is not something I would recommend to have a measure from slicer, but you can solve this with SELECTEDVALUE.
Here is some doc:
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.