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

[JappieD]

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?

[Samarth_18]

Hi @JappieD ,

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

[JappieD]

Hi, 

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

[Samarth_18]

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

[JappieD]

@Samarth_18 here a photo of the relationship. 

[Samarth_18]

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

[JappieD]

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

[daXtreme · Accepted solution]

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.

[JappieD]

@daXtreme It worked, thank you!