Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
108 | |
108 | |
108 | |
90 | |
61 |
User | Count |
---|---|
171 | |
138 | |
132 | |
102 | |
86 |