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 ...
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!

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.