Forum Discussion

Pete230's avatar
Pete230
Icon for Helper III rankHelper III
2 years ago

Create a costum column which counts consecutive negative numbers

Hi together; I would like to create a costum column C in power querry which counts the consecutive negative numbers in Column B. Which forml needs to be put in here: to achive the foll...
Need Help
Pete230's avatar
Pete230
Icon for Helper III rankHelper III
2 years ago

Dear Anonymous ,

 

thanks for the quick reply; unfortunatly i get an error saying can not be converted into a list:

 

my table and datatypes are the following:




Any idea how to solve that?

Cheers, Pete