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

     

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
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

 

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

    Thanks it works 😃

    I didn't know that only calculated columns could be use as filter

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi, ive tried this method, but seems its only shows max date on the filter slicer. how to make it also shows all dates, but will only select max date ? (especially when user access the link report, the page will automatically select max date, but still shows old dates)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I am using a Power BI dataset, I don't have the ability to create calculated columns, is achieving this possible?