Forum Discussion
mariomyhanh
3 years agoHelper I
Add custom column with calculation or if statement
Hello, i am a beginner when it comes to PowerBI. I am asking if someone would help of adding a column with conditions in power bi. if column A has anything that starts with a 5, then return the...
- 3 years ago
Use this
= if Text.StartsWith(Text.From([A]),"5") then -1*[B] else [B]๐ It's been a pleasure to help you | Help Hours: 11 AM to 9 PM (UTC+05:30)
How to get your questions answered quickly -- How to provide sample data
Vijay_A_Verma
3 years agoMost Valuable Professional
Use this
= if Text.StartsWith(Text.From([A]),"5") then -1*[B] else [B]
๐ It's been a pleasure to help you | Help Hours: 11 AM to 9 PM (UTC+05:30)
How to get your questions answered quickly -- How to provide sample data