Forum Discussion

Bhanuaripaka's avatar
Bhanuaripaka
Frequent Visitor
2 years ago
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 should be displayed as my invoice date for all my transactions.

Appreciate your help! 

Need Help
Tips and Tricks
  • Shravan133's avatar
    Shravan133
    2 years ago

    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 ()
    )

2 Replies

  • Shravan133's avatar
    Shravan133
    Super User
    2 years ago

    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 ()
    )