Forum Discussion
Find the last value
Hey Gwen78 ,
In Dax you can use the MAXX with the date as well. This link has a more in-depth review than you probably need but under number 4 it specifically calls out using the Maxx Date. Using MAXX DAX Function In Power BI To Calculate Recent Values (enterprisedna.co)
Thank you collinq for your answer.
My example is not good. I don't search the largest value but the value related to the last date. Instead of 60 for France - 1/6/21 it could also be 9 for example.
I have created a measure lastdate() to find the last date and it works, but I cannot use the related fonction in a measure.
Hey Gwen78 ,
In Dax you can use the MAXX with the date as well. This link has a more in-depth review than you probably need but under number 4 it specifically calls out using the Maxx Date. Using MAXX DAX Function In Power BI To Calculate Recent Values (enterprisedna.co)