Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi all,
How can I create a summary table from a fact table that return only the Row with the Max Date for each set of criteria?
Here is what I have so far, but I I haven't been able to get just the Max Date.
Solved! Go to Solution.
Data Summary =
var a = SUMMARIZE(
Data,
[Co],
[Division],
[Region],
[District],
[Center],
[Date],
[Amount]
)
RETURN MAXX(a,[Date])
Veja se ajuda
Tabela2 =
SUMMARIZE(
Tabela,
[Co],
[Division],
[Region],
[District],
[Center],
"Date", MAX(Tabela[Date])
)
Data Summary =
var a = SUMMARIZE(
Data,
[Co],
[Division],
[Region],
[District],
[Center],
[Date],
[Amount]
)
RETURN MAXX(a,[Date])
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |