Forum Discussion

Vividodo's avatar
Vividodo
Regular Visitor
6 years ago
Solved

PowerBI Running Total - Native Fuction - Missing Values Issue

Hi PowerBi Community,  I encoutered a problem with the format of the native "Running Total" function of Power Bi as below: For demonstration, I created a pivot table with the cumulative cashflow of...
Need Help
  • sturlaws's avatar
    sturlaws
    6 years ago

     

     

sturlaws's avatar
sturlaws
Resident Rockstar
6 years ago

Hi Vividodo 

 

try to recreate your quick measure, but this time use BucketOrder[Bucket] as field instead of Data[Bucket]. Also make sure you use BucketOrder[Bucket] on the columns of your matrix.

 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

Vividodo's avatar
Vividodo
Regular Visitor
6 years ago

Hi sturlaws 

Thank you for your advice. However, it produces the same result

 

Cheers,
Vividodo

  • sturlaws's avatar
    sturlaws
    Resident Rockstar
    6 years ago

     

     

    • Vividodo's avatar
      Vividodo
      Regular Visitor
      6 years ago

      Thank you for your solution and sorry for the previous misleading. 

      Cheers,
      Vividodo