Forum Discussion
Finding repeated values over consecutive dates
Hi Ashish,
Thanks for your reply. I'm sorry for not specifying, but I was replying to your post.
In your example above in power pivot, that particular measure successfully marks a "1" everytime there is a "0" in the data, but I need it to mark a "1" on any row that has a stretch of five 0's in succession.
For instance:
In the example you provided (see image below), you can see that the row "LMN" has five 0's in succession. I need some indicator to let me know that LMN has a grouping of five 0's.
You can also see in row XYZ there are only two zeros. There is no need to mark these.
I really appreciate everyone's help, and I'm using this as a learning opportunity and not just copy/pasting DAX. Having used standard pivot tables for years, I had no idea there was a whole new world with power pivot and Power BI until just a few months ago.
Thank you.
This is exactly what I'm looking for. I'm understanding what these are doing and I'm taking this as a learning opportunity. I see exactly what the difference and fix is between this and the last, and I feel silly it was so simple.
I appreciate your help immensely. I'm working with my mentors to get access to Power Query and DAX education.
Thank you.