topic Re: How do I get the last date (with date table) in DAX Commands and Tips

How do I get the last date (with date table)

JappieD — Wed, 23 Nov 2022 10:25:14 GMT

Hi,

I need to visualize the last date per categorie. When I do a Max(date[date[), it will show the last date of my date dable, that is somewhere in 2027. I need to know per categorie which day the last run was. Someone has any clue how to get to this point?

Re: How do I get the last date (with date table)

Samarth_18 — Wed, 23 Nov 2022 10:28:18 GMT

Hi JappieD ,

You can just summerize your Date column as Latest as shown below:-

Re: How do I get the last date (with date table)

JappieD — Wed, 23 Nov 2022 10:32:42 GMT

Hi,

Thanks for your comment. Tried that but it gives me the last value of my date table.

Re: How do I get the last date (with date table)

Samarth_18 — Wed, 23 Nov 2022 10:42:19 GMT

JappieD Do you have relationship between date table and actual table?

Re: How do I get the last date (with date table)

JappieD — Wed, 23 Nov 2022 10:48:17 GMT

Samarth_18 here a photo of the relationship.

Re: How do I get the last date (with date table)

Samarth_18 — Wed, 23 Nov 2022 10:55:42 GMT

JappieD So you are taking Categories from the dmt_bhr DimSchema and date from the dmt_bhr DimDate(2) right?

Re: How do I get the last date (with date table)

JappieD — Wed, 23 Nov 2022 10:58:54 GMT

Samarth_18 yes, that is correct. If i try it with 'pipeline run' from the fact table', it doesn't work either.

Re: How do I get the last date (with date table)

daXtreme — Wed, 23 Nov 2022 11:21:30 GMT

This is how you get the latest date that's in the current context:

[Latest Date] = MAXX( SUMMARIZE( FactTable, DateDimension[Date] ), DateDimension[Date] ) // or even simpler... [Latest Date] = MAX( FactTable[Date] ) // where the Date field is the one // that joins the fact table and // the dim.

Re: How do I get the last date (with date table)

JappieD — Wed, 23 Nov 2022 11:25:33 GMT

daXtreme It worked, thank you!