cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
i820017
Resolver II
Resolver II

Max 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)

i820017_0-1637698199748.png

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

 

Thanks

Dan

1 ACCEPTED SOLUTION
FarhanAhmed
Super User
Super User

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)

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
AbhiSSRS
Super User
Super User

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

i820017
Resolver II
Resolver II

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
Super User
Super User

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)

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors