cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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.

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?

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors