Forum Discussion
Resolver IIMax Date from a Column in a Paginated Report
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
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)
4 Replies
- AbhiSSRS
Solution Sage
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
mohammadyousafworked, thank you.
- FarhanAhmed
Community Champion
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)
i820017Yes, 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?
