cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## difference by row by hours date and product

Hello,

I am looking for urgent help.

I have table that looks like below , Table name is -  Difference

I want to calculate the difference by row from hour 0 to 23 for each date and each MeasurementName .

example: one measurement name has two dates, each date has hour 0 to 23 and I would like to calculate the diffrence bewteen hour 0 to 1, 1 to 2 so on where hour 0 will have diffrence always 0. Like wise for each measurement name.

currently i have below dax

diff = var diff = 'Difference'[Value]-
CALCULATE(SUM('Difference'[Value]),
FILTER('Difference',
'Difference'[Hr2]=EARLIER('Difference'[Hour])
)
)
return

if (diff=VALUE('Difference'[Value]),
0,
diff
)

which helps only for one day and one MeasurementName, if i try to use multiple dates and multiple measurementName it gives wrong result.

Please help me this is uregent and help with by using my column names.

Thank you.

2 REPLIES 2
Super User

@gaikwadaa123 , Create a new column

diff =
var _1 = CALCULATE(SUM('Difference'[Value]),
FILTER('Difference',
'Difference'[Hr2] = EARLIER('Difference'[Hour])-1 && 'Difference'[Date]=EARLIER('Difference'[Date])
)
return
if ( isblank(_1)
0,
'Difference'[Value] - _1
)

Helper II

Thank you for your response. I get below errors. can you help?