Calculation like excel

[ksnnidhi]

Is this calculation is possible in power bi

2 2

3 5

5 10

10 20

[ksnnidhi]

yes its fixed thank for your help

[TheoC · Accepted solution]

@ksnnidhi 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]

@ksnnidhi 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?