difference of two dates in fact

[KV2022]

Please help

I need to find difference of two dates in fact for multiple records and aggregate them together

ID Stage1  start   end   itrtn1

ID stage1 start     end   itrtn2

ID stage2 start   end   itrtn1

ID stage2 start     end   itrtn2

output  = ID  stage1 -- diff in days 

                ID  stage2     diff in days   

then it should be displayed as a matrix

[MahyarTF]

Hi,

You could create the column in your table as below :

Diff in Day = DATEDIFF( Sheet152[Last Fuel Purchase Date] , Sheet152[Fuel Purchasing Date] , DAY)

then use in your visual :

Appreciate your Kudos

[KV2022]

Thanks for the reply. I cant create columns. This should be a measure.

[Tahreem24]

@KV2022 So use any aggregate function like MIN or MAX.