Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
51 | |
46 | |
20 | |
16 | |
14 |
User | Count |
---|---|
108 | |
54 | |
31 | |
20 | |
18 |