Forum Discussion

Regular Visitor

3 years ago

Row by Row calculation for a measure

Hi, I have a tables Load and Generation which are connected to table Timeseries through datetime. One datetime in Timeseries has multiple datetime in 'Load',which I filter by site. Similarly one ...

Need Help

elegant_cow

Regular Visitor

3 years ago

I am sorry, I think I misunderstood the real problem.

I can calulated the 'Load_Generation_diff' per row now (as per your forumla) and I am trying to calculate another measure from it. This measure is called 'Generation Sold'

Generation Sold = IF( [Load_Gen_diff] < 0, ABS([Load_Gen_diff]) ,0)

My data is hourly so at the hourly level it all works (and it worked before as well)

but as soon as I aggregate up (from hourly to daily), the 'Generation sold' doesnt show anything. I thought this was being 'Load_Generation_diff was no longer calculating per row (even with the new formula).