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
Datagulf
Responsive Resident
Responsive Resident

How to create Age bins

I want to replicate the following table and am looking for the formula to achieve so. 

Datagulf_0-1669993067439.png

I have a Quotes with data that is as the following. 

Quote IDClient Name Quote Date 
1NAme1 12/11/2022 
2 NAme2 11/11/2022 
3 NAme3 09/11/2022 
4 NAme4 06/11/2022 
5 NAme5 02/11/2022 
6 NAme6 09/10/2022 
7 NAme7 09/07/2022 
8 NAme8 02/07/2022 
9 NAme9 05/06/2022 


The plan is to have the count of the quotes clustered in 0-30 days from today, 30-60 days from today and 60-90 days. All that surpasses should be in the rest than 90 days .. 
So if today's date is 2/12/2022, then it should go back and check up to 2/11/2022 and input the number of quotes that fall in that bracket between 0-30 days, and between 02/11/2022 to 02/10/2022 - Should input all that are 30 -60 days. 
Please assist. Thanks

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Datagulf , You can create a column like

 

New column =

var _day = datediff([Date], Today(), day)

return

Switch( True(),

_day <=30 , "   0- 30",

_day <=60 , "   31- 60",

_day <=90 , "   61- 90",

"> 90 ")

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Datagulf , You can create a column like

 

New column =

var _day = datediff([Date], Today(), day)

return

Switch( True(),

_day <=30 , "   0- 30",

_day <=60 , "   31- 60",

_day <=90 , "   61- 90",

"> 90 ")

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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