Forum Discussion

Uka's avatar
Uka
Frequent Visitor
3 years ago
Solved

Rolling Count that resets when a row value is zero

Hello , Please could you help me to calculate the rolling count of a column (~Category1 No) in AGG_Worked_Hours table; such that when the value is 1, it will do a rolling count but once the value be...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please kindly check the attached file and the below picture if it suits the requirement.
    Thank you.

     

Uka's avatar
Uka
Frequent Visitor
3 years ago

Hi Jihwan_Kim 

Many thanks for your help!  I really appreciate; but I got an error below; 

Please can I send my pbi file for you to see?

If yes, please can you talk me through how to attach the file as I can't find the attach botton in this window.

 

Many thanks

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi, 

I am not sure whether you can attached the file or not, but you can also share the link of the file.

If it is OK with you, please share the link (Onedrive link or googledrive link or dropbox link), and then I can try to look into it.

Thank you.