Forum Discussion

Millser's avatar
Millser
New Member
5 years ago
Solved

Running total for power Bi

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.

Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    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!

7 Replies

  • Migasuke's avatar
    Migasuke
    Icon for Memorable Member rankMemorable Member
    5 years ago

    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's avatar
      Millser
      New Member
      5 years ago

      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's avatar
        Migasuke
        Icon for Memorable Member rankMemorable Member
        5 years ago

        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.

    • Millser's avatar
      Millser
      New Member
      5 years ago

      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.