Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
My PBI File :-
Paul
https://www.dropbox.com/s/vadfrj5u5rxcypv/AR_ISDN%20v009%20trail.pbix?dl=0
Solved! Go to Solution.
@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 result
Appreciate a Kudos if this resolves your Query !!
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:
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, @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:
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
@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 result
Appreciate a Kudos if this resolves your Query !!
Hi All
Can some one help me how to make X axiz can sort in sequences ?
Hi Sir
This is beyond my expectation. This is better approach . ( my approach no goos , i create many field. )
Thank you
Paul
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |