Forum Discussion

Titatovenaar2's avatar
Titatovenaar2
Icon for Advocate II rankAdvocate II
5 years ago
Solved

Max Date Filter per ID from another Table, using EARLIER (pbix included)

Hi guys,   I'd like to view per a certain ID only the Max Date and values that correspond with that Max Date. I got this working for ID's within the same table, but the solution doesn't work for a...
Need Help
  • Titatovenaar2's avatar
    Titatovenaar2
    5 years ago

    Using the calculated table with the SUMMARIZE() function solved my problem.

    Make sure you summarize by whatever column you want, in my case the Clientnummer.

    Followed up by the MAXX statement, that will return per record in the table (in this case, per Clientnummer) the maximum value of any column of another table (in this case, 'SnapshotDatum').

     

    TEST2 = 
SUMMARIZE(  
    'DIM Klanten',
    'DIM Klanten'[Clientnummer],
    "Max SnapshotDate", MAXX(RaiAssessmentsV2, MAX(RaiAssessmentsV2[SnapshotDatum]))  
)

     

    Cheers!

Titatovenaar2's avatar
Titatovenaar2
Icon for Advocate II rankAdvocate II
5 years ago

Ok, I've seen those videos, and it was actually quite handy to look at those functions more closely.

 

However, in my situation I still don't know how to be able to filter a table using a MAX(date) based on an ID of a different table.

 

Any information on that?