Max date related valuesto display in the table and also day as Slicer

[Anonymous]

Hi, I have a table say SalesTable which shows the transactions based on the Date selection we make in the slicer.

Now, I also want this table to display the Max(Table[Date]) whenever the Dashboard is refreshed with data.

For Example, If I refresh the Dashboard today ie. 28th March it should display the Sales transaction which happened only on this date while we open the dashboard.

If we want to see Sales for some other day I should select it in Slicer and see corresponding Sales in the SalesTable.

May i know solution for both please?

Thanks!

[v-yulgu-msft]

Hi @Anonymous,

Please try this measure:

Sales measure =
IF (
    CALCULATE ( ISFILTERED ( TableName[Date] ), ALLSELECTED ( TableName[Date] ) ),
    SUM ( TableName[Sales Transaction] ),
    CALCULATE (
        SUM ( TableName[Sales Transaction] ),
        FILTER ( TableName, TableName[Date] = CALCULATE ( MAX ( TableName[Date] ), ALL ( TableName ) ) )
    )
)

Best regards,

Yuliana Gu

[Anonymous]

I think I have to correct my question. I need to display the max(Date) in a table chart which has Country, Sales, Sales person and so on.