Forum Discussion

mamunxv8's avatar
mamunxv8
Helper I
2 years ago
Solved

Date Wise Data Show

Hi,   I want to make a table like that. The problem is that I can't show the data with column-wise date. I don't want any calculation here; I want to show the last two entry date data.  Can I...
Need Help
  • mamunxv8's avatar
    mamunxv8
    2 years ago

    Thanks for the help. I found out different ways to set two days parallel. Also, as I want, find out the last two days from the dataset.

     

    Here is Dax formula:

    LastDayData =
    VAR MaxDate = CALCULATE(MAX('Tablename'[Date]), ALL('Tablename'[Date]))
    RETURN
    CALCULATE(SUM('Tablename'[Close]), 'Tablename'[Date] = MaxDate)
     
    SecondLastDayData =
    VAR SecondLastDate = CALCULATE(MAX('Tablename'[Date]), FILTER(ALL('Tablename'[Date]), 'Tablename'[Date] < MAX('Tablename'[Date])))
    RETURN
    CALCULATE(SUM('Tablename'[Close]), 'Tablename'[Date] = SecondLastDate)
     
    Thanks