Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Count of the number of Regions that have shown up 6+ times in any 30 day period.
That is...
If Denmark is the only region that has shown up 6+ times the answer would be 1.
If Denmark and UK have show up 6+ times the answer would be 2.
I am stumped as to where to start on this one....
Solved! Go to Solution.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, use a VAR to create a table of all of the relevant records. Use SUMMARIZE or GROUPBY to summarize that table variable to a new table variable. Use ADDCOLUMNS on this to add a COUNT or COUNTROWS. Then, use COUNTX on a FILTER of this last table variable with a filter of >=6 of your count.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, use a VAR to create a table of all of the relevant records. Use SUMMARIZE or GROUPBY to summarize that table variable to a new table variable. Use ADDCOLUMNS on this to add a COUNT or COUNTROWS. Then, use COUNTX on a FILTER of this last table variable with a filter of >=6 of your count.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |