Running total for power Bi

[Millser]

Hi,

I have a table which contans a bunch of values that correspond to behaviours (Green = 1, Yellow = 0.25, Orange = 0, Absent = 0 suspended = Clear all points and Warning = halve the points) and a table that hold the behaviours assigned to a student and also contains their daily final behaviour.

I was wondering how I would format a query that would calculate the running total for each daily behaviour.

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[Millser]

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.

[v-xulin-mstf · Accepted solution]

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!

[Ashish_Mathur]

Hi,

Please show the raw data and the expected result.

[Migasuke]

Hi @Millser ,
If I understand well, you need to have running total for your Behaviours (categories) and do the running calculation on date?
If yes, try similar approach I have here. Category would be your Behavior and Value your Points:

[Millser]

Do you know how I could express the value "Clear" as a numeric value? With it in it's current state the formular doesn work.

[Migasuke]

Hi @Millser ,
you need to either replace "Clear" with some numeric value in Power Query or maybe create a conditional column, where you definy numberic value for "Clear" and maybe other categories.

As Ashish sugested , it would be nice to show some data sample with required output.