Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @mvgust ,
Has the problem be solved? Please consider to mark the answer as solution if it works for you.
Best Regards,
Jay
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |