Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All
This should be a simple question - but for the life of me i cant see the formula i need - or at least my tiny brain cant process this at teh moment so need your help!
Basically I need to be able to count the number of times the values are within a specific row so i can then produce a nice report\count.
Note those in red - the right hand column is a calculated column counting the days between join date and last payment - I need to count the number of times of 0-50, 51-100, 101-150, 151-200, 200+
When i get this i will do the green also....but I cant get my head around how to do this.
Any help would be most appreciated.
Thank you
Hello,
Is this the desired result?
Regards,
Adrian
User | Count |
---|---|
20 | |
18 | |
17 | |
11 | |
7 |
User | Count |
---|---|
28 | |
28 | |
13 | |
12 | |
12 |