Forum Discussion
Gwen78
4 years agoNew Member
Find the last value
Hello, I have a table with 3 colums : Site / Date / Result I want to find the results associated to the last date of each site, to create an histogram with the last result per site. Example...
- 4 years ago
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)
collinq
4 years agoSuper User
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)