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 do it on Power BI? Thanks

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]))RETURNCALCULATE(SUM('Tablename'[Close]), 'Tablename'[Date] = MaxDate) SecondLastDayData =VAR SecondLastDate = CALCULATE(MAX('Tablename'[Date]), FILTER(ALL('Tablename'[Date]), 'Tablename'[Date] < MAX('Tablename'[Date])))RETURNCALCULATE(SUM('Tablename'[Close]), 'Tablename'[Date] = SecondLastDate) Thanks

Date Wise Data Show | Microsoft Fabric Community

7 Replies

mahenkj2
Solution Sage
2 years ago
Hi mamunxv8

I believe you can.
We can't see your table data, so assuming that your date column have many dates and you want to use a matrix visual and keep dates in column header but only last two dates. If so, you can use filter in power query to filter top 2 rows or so to keep 2 latest dates and then use that column in a matrix visual.

Hope it helps.

You can share sample data incase need more help.
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
- mahenkj2
  Solution Sage
  2 years ago
  Hi,
  I created a sample which gives output as below:
  
  Please find a demo file here. I have used multiple power query transformations here, you need to test if it works in your scenarion. Please ask questions as may be needed to clarify.
  
  https://drive.google.com/file/d/1AAcvPL3QSCT6C5-F2BmClDE_KWy8Elio/view?usp=sharing
  
  Hope it helps.
  - 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
Anonymous
Not applicable
2 years ago
Hi mamunxv8 ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng
- mamunxv8
  Helper I
  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