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 tried to drag this measure to my page filter.

But it doesn't work.

 

Do you know how I can solve this ?

 

Thanks

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

     

6 Replies

  • 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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    You cannot use measures at the page filter level. You can use a calculated column at the page level however. I would suggest converting your measure to a calculated column first and see if your DAX translates to fit your issue.