Forum Discussion
Solved
Measure IF String Equals One Value THEN SUM ELSE SUM2
Hey everyone, I am not that experienced in PowerBI since I have mostly done calculations like that on Tableau before. So what I need to do is in principle a basic IF ELSE calculation. Some stores...
Hi Manolsmn
You can use the below to achieve what you want. Just click "New Column" in the ribbon and then you can apply the following:
Calculated Column = IF ( 'Table'[Column] = "CombineStore" , 'Table'[SR] + 'Table'[SR] , 'Table'[SR] )
Note that the above is based on your requirement to combine two values which I assume are in two separate columns.
Hope this helps.
Theo
TheoC
Community Champion
Community ChampionHi Manolsmn
You can use the below to achieve what you want. Just click "New Column" in the ribbon and then you can apply the following:
Calculated Column = IF ( 'Table'[Column] = "CombineStore" , 'Table'[SR] + 'Table'[SR] , 'Table'[SR] )
Note that the above is based on your requirement to combine two values which I assume are in two separate columns.
Hope this helps.
Theo