values of same dates are sum up automatically but need display seperately

[Anonymous]

creating a new column by subtract two dynamic columns in matrix table

There are two values with same date and when i use date as header the value of same dates getting sum up and display as single column in the dashboard.  there is a field called "type" is the only differentiator for two values of the same date. kindly help on the below

1. I need to display the value of DATE with Type 0 and Type 1 Separately

2. I need to display the values of Latest Date subtract with before Date Only if the Type is 0.

 shown in the attached image as examples  1. source file screenshot and 2. matrix visualization screenshot

[Anonymous]

I need to visualize the data wherein the dates are dynamic. If i use the index and use the index filter the subtract the data, then if the additional dates are added, then it does not subtract the latest date with previous date.

The differentiator between two same dates is field called "Type" which consists of two values 0 and 1. Zero refers distinct dates and 1 refers same date.

I need to display the following.

1. Latest date (Type=0)

2. Difference(Subtract)=Latest_Date - Previous Date

3. Latest_Date (Type=1)

[amitchandak]

@Anonymous , Power bi always groups the data. So if need line level, You can add Type to matrix column and expand.

You can add an index column and can use that in mtarix column

Power Query- Index Column: https://youtu.be/NS4esnCDqVw