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])

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Dmoetnogleren ,

I create two tables and create One-to-Many relationship.

Then I create a measure and here is the DAX code.

RecentDate = 
CALCULATE(
    MAX(FactTable[Startdate]),
    FILTER(
        FactTable,
        FactTable[ID] = RELATED(DIMtable[ID])
    )
)

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.