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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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