Forum Discussion
Calculation like excel
Is this calculation is possible in power bi
2 2
3 5
5 10
10 20
Anonymous everything is possible in Power BI (except some things) but all things are possible... just not everything.
Create a calculated column like below:
Calculated Column =
SWITCH (
TRUE () ,
'Table'[Column] = 2 , 2 ,
'Table'[Column] = 3 , 5 ,
'Table'[Column] = 5 , 10 ,
'Table'[Column] = 10 , 20 ,
BLANK()
)Enjoy 🙂
3 Replies
- TheoC
Community Champion
Anonymous everything is possible in Power BI (except some things) but all things are possible... just not everything.
Create a calculated column like below:
Calculated Column =
SWITCH (
TRUE () ,
'Table'[Column] = 2 , 2 ,
'Table'[Column] = 3 , 5 ,
'Table'[Column] = 5 , 10 ,
'Table'[Column] = 10 , 20 ,
BLANK()
)Enjoy 🙂
- TheoC
Anonymous can you kindly look at my response to your solution and accept it as solution to ensure others can find it if they too run into a similar issue?