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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Paulyeo11
Impactful Individual
Impactful Individual

How to compute Aging Day to 1 to 30 Day 31 to 60 Day ?

2 ACCEPTED SOLUTIONS
jaideepnema
Solution Sage
Solution Sage

@Paulyeo11  use the following DAX

 

Agein Bucket = SWITCH(TRUE(),

AND(Query1[AGING]>0,Query1[AGING]<=30),"1-30 Days",

AND(Query1[AGING]>30,Query1[AGING]<=60),"31-60 Days",

AND(Query1[AGING]>60,Query1[AGING]<=90),"61-90 Days",

AND(Query1[AGING]>90,Query1[AGING]<=120),"91-120 Days",

AND(Query1[AGING]>120,Query1[AGING]<=150),"121-150 Days",

AND(Query1[AGING]>150,Query1[AGING]<=180),"151-180 Days",BLANK())

Here is the required resultcommunity.png

Appreciate a Kudos if this resolves your Query !!

View solution in original post

v-robertq-msft
Community Support
Community Support

Hi, @Paulyeo11 

According to your description, you want to make the value of measure[AGING] displays Split date counts, you can try this measure to replace your current measure:

AGING =

var _datediff=Datediff([AR Invoice Date],today(),day)

return

SWITCH(

    TRUE(),

    _datediff<=30,"1 to 30 Day",

    _datediff<=60,"31 to 60 Day",

    "Over 60 day"

)

And you can get what you want, like this:

v-robertq-msft_0-1605598760412.png

 

You can download my test pbix file here

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
v-robertq-msft
Community Support
Community Support

Hi, @Paulyeo11 

According to your description, you want to make the value of measure[AGING] displays Split date counts, you can try this measure to replace your current measure:

AGING =

var _datediff=Datediff([AR Invoice Date],today(),day)

return

SWITCH(

    TRUE(),

    _datediff<=30,"1 to 30 Day",

    _datediff<=60,"31 to 60 Day",

    "Over 60 day"

)

And you can get what you want, like this:

v-robertq-msft_0-1605598760412.png

 

You can download my test pbix file here

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Robert 

your script very smart , it will sort by itself.

Paul

Hi Robort

Thank you very much

Paul

jaideepnema
Solution Sage
Solution Sage

@Paulyeo11  use the following DAX

 

Agein Bucket = SWITCH(TRUE(),

AND(Query1[AGING]>0,Query1[AGING]<=30),"1-30 Days",

AND(Query1[AGING]>30,Query1[AGING]<=60),"31-60 Days",

AND(Query1[AGING]>60,Query1[AGING]<=90),"61-90 Days",

AND(Query1[AGING]>90,Query1[AGING]<=120),"91-120 Days",

AND(Query1[AGING]>120,Query1[AGING]<=150),"121-150 Days",

AND(Query1[AGING]>150,Query1[AGING]<=180),"151-180 Days",BLANK())

Here is the required resultcommunity.png

Appreciate a Kudos if this resolves your Query !!

Hi All 

Can some one help me how to make X axiz can sort in sequences ?

Paulyeo11_0-1605651191466.png

 

Hi Sir

This is beyond my expectation. This is better approach . ( my approach no goos , i create many field. )

Thank you 

Paul

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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