Forum Discussion

asanand's avatar
asanand
Regular Visitor
9 years ago
Solved

Finding the max date row between date range and date range is dynamic.

Hello  I am new to PowerBI and looking for one solution. I tired to find the solution in this forum and do a lot of google but not able to find anything related to this.    Problem:  There is a t...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi asanand,

     

    You can use below formula to get the max date of each type based on slicer:

     

    Measure:
Max Date = 
var curr=LASTNONBLANK(Sheet4[Column1],[Column1])
Return
MAXX(FILTER(ALLSELECTED(Sheet4),[Column1]=curr),[Column2])

     

     

    Regards,

    Xiaoxin Sheng

Habib's avatar
Habib
Continued Contributor
9 years ago

Please use DatesBetween filter inside a calculate functon.