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

[GeorgWildmoser]

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:

Result: 

Desired result: 

[GeorgWildmoser · Accepted solution]

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]

@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

[GeorgWildmoser]

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.