Show latest date of each table into one card or table

[Anonymous]

Hello everyone i have a dimDate table with date column

Revenue table with date column and its values 

Expense table with date column and its values

Tax table with date column and its values

All tables have a relationship with dimdate date

I want to create one measure and a table or card that shows each table what latest date it has

[Anonymous · Accepted solution]

Hi @Anonymous ,

Like this?

Just create three measures to get latest date in each table, as the following writes:

expense latest date = MAXX(ALL('Expense table'),'Expense table'[date])

Other tables are written similarly to this.

For better understanding please see my pbix file.

Best regards,

Community Support Team Selina zhu

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