Forum Discussion

FredLEGUEN's avatar
FredLEGUEN
Icon for Helper III rankHelper III
7 years ago
Solved

Filter a page based on MAX Date

Hi,   I would like to know how I can filter a page of my PowerBI report automatically on the last date of my database.   I have created a basic measure MaxDate = MAX(DateColumn) Then I have trie...
Need Help
  • Vvelarde's avatar
    Vvelarde
    7 years ago

    FredLEGUEN 

     

    Hi, try creating a calculated column 

     

    LastDateInData =
IF ( Table1[OrderDate] = MAX ( Table1[OrderDate] ), 1, 0 )

    and filter when this column is 1.

     

    Regards

     

    Victor