Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
GeorgWildmoser
Frequent Visitor

Need help to display the max date of a slicer in a pivot, which is also connected to the date table.

Hello,

I have a report with a pivot table for displaying receivables. The pivot table contains, among other things, the document date.
I also have a slicer on the document date so that the user can set his own time period for the view. Screenshot below.

 

I have a problem when I want to add another column in the pivot, which should contain the max. selected document date of the slicer.

 

My result is usually either a cross product (see further screenshot) or the max. date of the date table and not of the slicer.

 

How does the Dax formula or formula and calculated column have to look so that I get the column with the value in the pivot?

 

Thank you very much for your help

 

Starting Point:

GeorgWildmoser_0-1722528471332.png

 

Result: 

GeorgWildmoser_1-1722528512316.png

Desired result: 

GeorgWildmoser_2-1722528983550.png

 

1 ACCEPTED SOLUTION
GeorgWildmoser
Frequent Visitor

Hi, I got a solution to the problem via another post on the DAX forum. See: 

(3) Solved: Re: How to show max value from slicer in pivot - Microsoft Fabric Community

View solution in original post

3 REPLIES 3
GeorgWildmoser
Frequent Visitor

Hi, I got a solution to the problem via another post on the DAX forum. See: 

(3) Solved: Re: How to show max value from slicer in pivot - Microsoft Fabric Community

amitchandak
Super User
Super User

@GeorgWildmoser , You can create a measure maxx(allselected(Table), Table[document date]) 

 

You will not be able to group the rows. but each row will show max value

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Hi, thanks for the feedback, but it should be groupable and not show the max value for each row. This is exact the problem i looking for a solution.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.