Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
79 | |
74 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |