Forum Discussion

project101's avatar
project101
Frequent Visitor
4 years ago
Solved

Runing Sum Filter

running sum m- query  The Code   ( ) as list => let pList = {1,2,3,4,5,6,7,8,9} , runSum=List.Generate( ()=>[ xx =0 , zz=pList{0} ], each [xx] <=List.Count(pList) , each [ xx=[xx]+1 , zz = [z...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi  project101 ,

     

    First convert list to table:

    Then remove errors,filter rows is greater than 3:

     

    And you will see:

    Check my sample .pbix file attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

     

v-kelly-msft's avatar
v-kelly-msft
Community Support
4 years ago

Hi  project101 ,

 

First convert list to table:

Then remove errors,filter rows is greater than 3:

 

And you will see:

Check my sample .pbix file attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!