Forum Discussion
Rolling Count that resets when a row value is zero
Hi,
Please kindly check the attached file and the below picture if it suits the requirement.
Thank you.
Super UserHi,
Please check the below attached pbix file.
It is quite difficult to understand the sample that you provided, but I tried to create my own sample.
I am not sure if I understood your requirement correctly, but I tried to reset calculation every zero by using the concept of PARTITIONBY DAX function.
1. create a partition column in the table.
2. use this partition column in WINDOW DAX function.
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
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.
Hi Jihwan_Kim
Many thanks once again.
I have save the file in onedrive and here is the link: https://drive.google.com/drive/folders/1UL5bBfUs79bHBdF_jymqVDYDdeH7ehyM?usp=drive_link
I have included the sample pbi file, dataset and expected output in the folder.
Thanks once again for your help!
- Jihwan_Kim
Hi,
I cannot find any files in the folder.
Could you please check?
Thank you.
- Jihwan_Kim
Hi,
I also created a short blog post about solving the similar problem.
Please refer to the link: How I create Cumulative Sums that resets whenever value is zero (jihwankimcscp.wixsite.com)