Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
l all,
I have been bumping my head into the wall all day trying to figure out this formula and why it's not working.
I have this formula:
Nol to pay buckets - case2 = IF([NOL to Payment]<=1,"Same Day",IF([NOL to Payment]>1 && [NOL to Payment] <=7,"1-7", IF([NOL to Payment] >7 && [NOL to Payment]<=10,"7 -10 Days",IF([NOL to Payment]>10 && [NOL to Payment] <=18, "10-18 Days",">10"))))
Can you please advise?
Thank you,
M
Solved! Go to Solution.
Hi @mluanacruz
How are you calculating your [NOL to Payment] measure? Please provide the code.
With the sample data I set up and this measure
Nol to pay buckets =
SWITCH(
TRUE(),
ISBLANK([NOL_to_Payment]), BLANK(),
[NOL_to_Payment]<=1,"Same Day",
[NOL_to_Payment]>1 && [NOL_to_Payment] <=7,"1-7",
[NOL_to_Payment] >7 && [NOL_to_Payment]<=10,"7 -10 Days",
[NOL_to_Payment]>10 && [NOL_to_Payment] <=18, "10-18 Days",
">10")
Things seem to work correctly
Regards
Phil
Proud to be a Super User!
Hi @mluanacruz
How are you calculating your [NOL to Payment] measure? Please provide the code.
With the sample data I set up and this measure
Nol to pay buckets =
SWITCH(
TRUE(),
ISBLANK([NOL_to_Payment]), BLANK(),
[NOL_to_Payment]<=1,"Same Day",
[NOL_to_Payment]>1 && [NOL_to_Payment] <=7,"1-7",
[NOL_to_Payment] >7 && [NOL_to_Payment]<=10,"7 -10 Days",
[NOL_to_Payment]>10 && [NOL_to_Payment] <=18, "10-18 Days",
">10")
Things seem to work correctly
Regards
Phil
Proud to be a Super User!
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |