Hi there,
I have a table called Delinquency. This table has many weekly reports since last year to March 2023. Each report has Friday date
ID | date Report |
1 | 3/3/2023 |
2 | 3/3/2023 |
I try to create a Slice with the last report.
Thanks for any help
The last row added:
[_RowNumber] = MAX(Delinquency[_RowNumber])
All rows with the most recent date:
[date Report] = MAX(Delinquency[date Report])
Perfect!!!, thank you
User | Count |
---|---|
16 | |
13 | |
8 | |
7 | |
4 |