Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |