Solved: Calculation like excel

ksnnidhi · ‎07-28-2022

Is this calculation is possible in power bi

2 2

3 5

5 10

10 20

TheoC · ‎07-28-2022

@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 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

View solution in original post

ksnnidhi · ‎08-03-2022

yes its fixed thank for your help

TheoC · ‎07-28-2022

@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 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

TheoC · ‎08-01-2022

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

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias