Forum Discussion
Slicer Max Date
Hi everyone,
I'm struggling to create a measure which will show max date selected by slicer excluding row context filter.
I have three dimensions linked to one fact table.
Dim Reporting date
Dim Transaction type
Dim Customer
And a Transactions fact with numerous measures and foreign key to all three dimensions.
Data Model:
What i would like to see is below example. So based on date slicer show max slicer date in all rows.
Both Slicer Date and Transaction Date are being used from the Reporting Date Dimension.
Thank you.
2 Replies
amitchandak thank you for replying, however I did try this and what I am getting is max date per customer.
In the example above slicer date value showed 01/03/2021 for all three Customer A rows.
Any other suggestions?
Thank you.
