Slice by last Report

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

IDdate Report
13/3/2023
23/3/2023

I try to create a Slice with the last report. 

Thanks for any help

 

0 2 81
2 REPLIES 2

The last row added:

[_RowNumber] = MAX(Delinquency[_RowNumber])

All rows with the most recent date:

[date Report] = MAX(Delinquency[date Report])

Perfect!!!, thank you