How to show max value from slicer in pivot
Hi, I have a pivot with documents and a slicer on the document date. The pivot contains the document and the respective document date. My problem: The pivot should be extended by another column - with the maximum selected document date of the slicer. The result is a cross product. What am I doing wrong? Thank you for your help. MyMeasure: MaxSliceDocumentDate = maxx(allselected(TimeDoc), TimeDoc[Date Date]) Starting Point: Result after adding Measure: Needed Result:
