Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
Hi,
Thanks for your comment. Tried that but it gives me the last value of my date table.
@Samarth_18 yes, that is correct. If i try it with 'pipeline run' from the fact table', it doesn't work either.
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.
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
84 | |
39 | |
25 | |
21 |