Forum Discussion
Solved
Filters/slicers over calculated (average) values in line chart
Hi all, Great community, I was able to find almost all solutions and answers to the questions I've had. But the one remains whcih I am struggling to deal with. I have a simple table like below ...
I guess I might need to create a 'calculated column' in PowerBI based on 'Value', Report and R.Period...
have tried with this but numbers are not correct
Running Total COLUMN = CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table' ), 'Table'[R.Period] <= EARLIER ( 'Table'[R.Period] ) )
R.Period is not a number/date in my case, wondering if this is causing a problem