Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have an excel file with columns (months) and rows (A-B-C etc. are clients) and below every client there is the name of a provider. I want to know how many clients have at least two providers (or more) simultaneously for at least four months.
I will try to make a dummy in PowerBi to make things clear
@Stevianne You likely want to unpivot your Month columns as a first step.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |