Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Return Latest Date

Hi all,     I have two tables. Location & Monitoring Date. I need to display the latest monitoring date of each location.   I was able to do it using the Latest function in PBI.       ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    HI Anonymous

     

    You might be able to solve it using a calculated measure.

     

    This might be close.  Jsut replace the Table4 with your own tablename

     

    Measure = 
    CALCULATE(
        LASTDATE(
            'Table4'[Latest Monitoring_Date]),
            ALLEXCEPT(Table4,Table4[LocCode]
                )
                )
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

HI Anonymous

 

You might be able to solve it using a calculated measure.

 

This might be close.  Jsut replace the Table4 with your own tablename

 

Measure = 
    CALCULATE(
        LASTDATE(
            'Table4'[Latest Monitoring_Date]),
            ALLEXCEPT(Table4,Table4[LocCode]
                )
                )