Max Date from a Column in a Paginated Report

[i820017]

Hey Everybody,

I just created a paginated report from a Power BI report on the cloud.
Anyway, I only want the Max date to show up for the column 'Date Last Quoted' for each Sales Rep. My report shows all of the dates for each Sales Rep as seen below when I use Max. Here is the expression that I used to get the 'Date Last Quoted' column =Max(Fields!QUOTE_CREATE_DT.Value)

Does anyone know what I can do to only get the Max Date? In this case,10/13/2021

Thanks

Dan

[AbhiSSRS]

Hi! 

Please run this in context of the dataset eg " =Max(Fields!Month.Value, "Main")  where Main is the dataset name. 

Ideally your expression should have worked as the tablix would have bound to the dataset directly. Please let us know on your daataset details in case this dsn't work

[mohammadyousaf]

worked, thank you. 

[i820017]

Yes, I created groups in my SSRS report. Moreover, I tried grouping by 'Date Last Quoted' and that didn't work for me. How do you group with dates in SSRS?

[FarhanAhmed · Accepted solution]

MAX will work on the grouping of data... Did you create groups in your table Matrix ?

Add Grouping To Table Reports In SSRS (tutorialgateway.org)