Forum Discussion
Helper IIIAdd results from consecutive days column
I was able to succesfully add a consecutive days columns using the below post:
https://community.powerbi.com/t5/Desktop/dax-grouping-consecutive-days/td-p/488880
I now need to use the results of consecutive days output to add the instances. So in the example below I need a measure that will disaplay 4 as the result for the the first grouping, 3 for the second grouping and so on.
Once I have that I'll be setting up an IF statement so if the new measure is >4, Yes otherwise No
Hi mvgust ,
If the value you are refering is a column you can do a similar measure to this one:
Counting_Values = COUNT('Table'[Consecutive Days])However this needs some context meanig that you need to have the Consecutive days on a filter to get the data then for the next measure you need to do:
Yes/No = IF([Counting_Values]>4, "Yes", "No")Has you can see below the values are presented, be aware that when you have more than one value the results may not be according to what you need has you can see on the total line.
2 Replies
- MFelix
Super User
Hi mvgust ,
If the value you are refering is a column you can do a similar measure to this one:
Counting_Values = COUNT('Table'[Consecutive Days])However this needs some context meanig that you need to have the Consecutive days on a filter to get the data then for the next measure you need to do:
Yes/No = IF([Counting_Values]>4, "Yes", "No")Has you can see below the values are presented, be aware that when you have more than one value the results may not be according to what you need has you can see on the total line.
Hi mvgust ,
Has the problem be solved? Please consider to mark the answer as solution if it works for you.
Best Regards,
Jay
