topic Re: Calculation like excel in DAX Commands and Tips

Calculation like excel

ksnnidhi — Thu, 28 Jul 2022 22:04:07 GMT

Is this calculation is possible in power bi

2 2

3 5

5 10

10 20

Re: Calculation like excel

TheoC — Fri, 29 Jul 2022 01:05:22 GMT

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 🙂

Re: Calculation like excel

TheoC — Tue, 02 Aug 2022 02:19:22 GMT

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?

Re: Calculation like excel

ksnnidhi — Wed, 03 Aug 2022 16:09:43 GMT

yes its fixed thank for your help