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

 

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?