Forum Discussion

anandsoftweb's avatar
anandsoftweb
Icon for Advocate V rankAdvocate 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