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
mamunxv8's avatar
mamunxv8
Helper I
2 years ago

 

Thanks for your help. Here is the sample data set. Your assumption is correct. There are so many dates, and I only want to show the last two dates on the report. How can I do it using power query?

 

I also tried to make a matrix table, but it shows like that....

 

 

 

Thanks

 

  • mamunxv8's avatar
    mamunxv8
    Helper I
    2 years ago

    Thanks for your help. Actually, i want to show the table data without any calculation. Just like the images. Please see the data 03-oct-23 and 02-oct-23. I want to show them separately on two columns without any calculation. 

    If you need need the data set please take a look below. I only want to show close value on the report.

     

    As your last solution i also want to use Matrix table but i can't do it. Please take a look in below

     

     

    Thanks again