topic Re: percent change by rows in DAX Commands and Tips

percent change by rows

gaikwadaa123 — Mon, 11 Oct 2021 23:30:45 GMT

Hello, I need urgent help.

I have below table

I would like to calculate the percent change of the 'Value' column for each Hour.

So that 0 hour will have 0 as percent change always and it will start from 0-1, 1-2,2-3 hour so on... till 23 hour and for each MeasureDate-copy and each MeasurementName

Also please consider 'MeasureDate-copy' column and MeasurementName like (various Prducts), so that for each measurementname formula will calculate the percentage change from hour 0 to 23 for that sepecific day only. and so on.

Pleas help me by using my column names. I really appriate any assistsnace.

Re: percent change by rows

amitchandak — Tue, 12 Oct 2021 03:33:39 GMT

gaikwadaa123 , Try a new measure like

sum(Table[Diff])- calculate(sum(Table[Diff]), filter(Table, Table[Date] = max(Table[Date]) && Table[hour] = max(Table[hour]]) -1 ))

Re: percent change by rows

gaikwadaa123 — Tue, 12 Oct 2021 12:30:30 GMT

I am looking for the precentage change which should include devide statement. With your formula i can see result like below

It is calculating same result for all rows. I want to see the percentage change for value column by each hour.

Can you modify and check ?

Re: percent change by rows

gaikwadaa123 — Wed, 13 Oct 2021 15:38:46 GMT

Did you check my reply?

Can you help me?

Re: percent change by rows

Icey — Thu, 14 Oct 2021 09:35:00 GMT

Hi gaikwadaa123 ,

Please create it as a calculated measure, not a calculated column.

If you want to create a calculated column, try this:

Column = Table[Diff] - CALCULATE ( SUM ( Table[Diff] ), FILTER ( Table, Table[MeasurementName] = EARLIER ( Table[MeasurementName] ) && Table[Date] = EARLIER ( Table[Date] ) && Table[hour] = EARLIER ( Table[hour] ) - 1 ) )

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: percent change by rows

Icey — Wed, 03 Nov 2021 05:15:34 GMT

Hi gaikwadaa123 ,

Can this work?

Best Regards,

Icey

Re: percent change by rows

gaikwadaa123 — Mon, 08 Nov 2021 15:37:43 GMT

thank you it worked. I am looking for another same issue,

I have two tables Difference and history ,

I would like to calculate the difference between Difference(actual) and History(value) colums based on the Hours and rate area.

Here is the screenshot: