Forum Discussion
Helper IIpercent change by rows
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.
Helper III 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 ?
Community SupportHi 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.
- Icey
- gaikwadaa123
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: