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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.