Forum Discussion
Solved
Display maximum slicer selected values in a table visual
Hi there! I am looking for help with a DAX measure which should display max selected date value slicer in a table visual. eg: max transaction date in slicer below is 8/07/2024 , I want that date...
Hi,
Try this:
MaxSelectedDate =
CALCULATE (
MAX ( 'DateTable'[Date] ),
ALLSELECTED ( 'DateTable' )
)and then, you can create another measure to display the max selected date as the invoice date for all transactions:
InvoiceDate =
VAR MaxDate = [MaxSelectedDate]
RETURN
IF (
NOT ISBLANK ( MaxDate ),
MaxDate,
BLANK ()
)
Thank you Shravan133 . It worked, really apppreciate your help.