Calculation like excel

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 🙂