date difference per value

[qwertzuiop]

Hello dear Power BI Community

Following problem:

I would like to add in Power BI the 3th column given these informations:

It should calculate the date difference per Product off the row above.

Product	Date	Date_Difference_per_Product
A	01.06.2022	0
B	09.06.2022	0
A	10.06.2022	9
A	15.06.2022	5
B	20.06.2022	11
B	25.06.2022	5

Thank you very much for your contribution.

Cheers

qwertzuiop

[ddpl]

@qwertzuiop try this

Column = var _A = 'yourTable'[Product]

         var _B = CALCULATE(MAX('yourTable'[Date]),FILTER('yourTable','yourTable'[Date] <EARLIER('yourTable'[Date])),'yourTable'[Product] = _A)
         var _C = DATEDIFF('yourTable'[Date],_B,DAY)

         return

         if(_C = BLANK(),0,abs(_C)

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

Date Diff per Product CC =
VAR _previousdate =
    MAXX (
        FILTER (
            Data,
            Data[Product] = EARLIER ( Data[Product] )
                && Data[Date] < EARLIER ( Data[Date] )
        ),
        Data[Date]
    )
RETURN
    IF ( _previousdate = BLANK (), 0, INT ( Data[Date] - _previousdate ) )

[Water]

Dear Jihwan_Kim

PREVIEW

You solution here should work with my problem here as posted on the Forum , but I cannot get it to work. Should you have a moment to spare, may I ask you to please have a look? The applicable Power BI file is here. 

I sincerely thank you!

W