Forum Discussion

Dmoetnogleren's avatar
Dmoetnogleren
Regular Visitor
2 years ago
Solved

Filter question

Hello,   Can anyone help with the following?   I have a DIMtable like this: ID Name person 1 X 2 Y   And a Fact table like this: ID Startdate 1 10-10-2020 2 1-8-202...
  • Dmoetnogleren's avatar
    Dmoetnogleren
    2 years ago

    Thank you for your answers. I cannot get it working, but I found another solution:

    RecentStartDate = LASTDATE('Fact'[Start Date])

     

Kaviraj11's avatar
Kaviraj11
Solution Sage
2 years ago

Hi,

 

Please create a measure as below and make sure to have a relationship between ID from two tables:

 

MostRecentStartDate =
VAR MaxDatePerID =
    CALCULATE(
        MAX('Fact'[StartDate]),
        ALLEXCEPT(Dim, Dim[ID])
    )
RETURN
    MaxDatePerID
 

 

Regards,

Kaviraj