Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
Anonymous
Not applicable

Count Values in a Row

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.

PBI - Dax Query.png

 

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

1 REPLY 1
avanderschilden
Resolver I
Resolver I

Hello,

 

Is this the desired result?

 

Capture.PNG

Regards,

 

Adrian

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors