Forum Discussion
Running total for power Bi
Hi Millser,
If the value is 'clear', what the calculation logic of your expected output?
You can try measure as:
IF( max'table'[value]="Clear", [logic of 'clear'] [logic of running total] )If you still have some question, please provide the sample data and expected output.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
The expected result that that beside the name of the student would be their behaviour and running total. However I cannot seem to calculte this running total becasue one of my values is called "clear" and it is not numeric, I am unsure how to express this as a numeric value in order to calculate it.
Community SupportHi Millser,
If the value is 'clear', what the calculation logic of your expected output?
You can try measure as:
IF(
max'table'[value]="Clear",
[logic of 'clear']
[logic of running total]
)If you still have some question, please provide the sample data and expected output.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!