Forum Discussion
HaiVN
Helper III
Helper IIIIf then else i power query
Hello , I need supports from community! I have a data with 2 columns : Company ( text) and Sale ( number). I want to create a column which shows: if [Company] = "A" then [Sale] = - [Sale] else ...
Hi HaiVN
Did you solve your problem? Based on my testing, the reply given by Akash_Varuna seems to get you the results you want.
If Akash_Varuna 's reply was helpful, would you consider marking his answer as a solution? Please feel free to let us know if you need further assistance.
Best Regards,
Yulia Xu
HaiVNHelper III
Helper IIIAkash_Varuna
if [Company] = "A" then -[Sale] else if [Company] = "B" then -[Sale] else [Sale]
Hi HaiVN
Did you solve your problem? Based on my testing, the reply given by Akash_Varuna seems to get you the results you want.
If Akash_Varuna 's reply was helpful, would you consider marking his answer as a solution? Please feel free to let us know if you need further assistance.
Best Regards,
Yulia Xu