Forum Discussion

anandsoftweb's avatar
anandsoftweb
Advocate V
9 years ago
Solved

DAX expression for Max Date data display in Table

Hello All,   I am looking for MAX date from Date column and based on that output table will be display on max date   Yes and No is Two filter slicer   Below is the sample data   ID Name ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi anandsoftweb

     

    From the description of the problem you want to find the max date for a given month and year from the data table.

     

    1. Create a calculated column YearMonth = Year(dataTable[Date]) * 100 = Month (dataTable[Date])

     

    2. Create another caculated column

         MaxDate = CALCULATE(MAX(dataTable[Date]),FILTER(dataTable,[YearMonth]=EARLIER(dataTable[YearMonth])))

     

    3. Now plot and you will get your desired output.  Sample output based on the data.

     

     

    If this solves your issue, please accept it as a solution and also give KUDOS.

     

    Cheers

     

    CheenuSing

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I too want a similar output, wherein the table while refreshing everyday it should show the Max (Table[Day]) and its related values only in the Table Chart. Also I have a Slicer with same Day column, while we make selections values in chart should change accordingly. Can someone tell me how should I solve this?

DhanshreeH's avatar
DhanshreeH
New Member
2 years ago

Can anybody help on this. I am also want to know the solution? I do have a similar requirement.