cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

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?

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

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

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors