Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi fellows,
Im trying to make a if statement but there must be something wrong on my calculated column. Best way is show you what i am doing.
Solved! Go to Solution.
Hi @Anonymous ,
Could you please try create the Importe Neto LY as a measure to use. Based on my test, it works fine on my side.
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Could you please try create the Importe Neto LY as a measure to use. Based on my test, it works fine on my side.
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Indeed! works!
Now, can I create a multiple if statements to achieve several conditions?
Range = var r = CALCULATE([Importe Neto LY]) return (IF(r >= 0&&r <= 500;"0-500";IF(r >= 501&&r <= 50000;"501-50000";"Dif")))
I want to create IF and Else to put some net sales range's.
Regards
Hi @Anonymous ,
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Works proper!!
Thanks a lot
Hi @Anonymous ,
We can use the SWITCH function to archive your requirement:
Range = VAR r = CALCULATE ( [Importe Neto LY] ) RETURN SWITCH ( TRUE (); r >= 0 && r <= 500; "0-500"; r >= 501 && r <= 50000; "501-50000"; r >= 50001 && r <= 500000; "50001-500000";
-- Add more condition here "Dif" )
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |