Forum Discussion

BBIUser's avatar
BBIUser
Helper IV
8 years ago
Solved

How to use the CASE statement in Power BI?

Hi,   1) How do I convert the below CASE statement to DAX in Power BI?    case when cCount > 0 and ThreeYrAvg > 0 then case when cCount - ThreeYrAvg >= 5 and round( ( ( cCount * 1.00 - ThreeYrAvg...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI BBIUser,

    I've created a sample data and used custom column to use -IF-ELSE-IF statements to get the result you need as shown below in images.

     

    -------------------------------------------------------------- 

    --------------------------------------------------------- 

    Let me know if any doubt persists.

    Thanks and Regards,

    Piyush 

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI BBIUser,

I've created a sample data and used custom column to use -IF-ELSE-IF statements to get the result you need as shown below in images.

 

-------------------------------------------------------------- 

--------------------------------------------------------- 

Let me know if any doubt persists.

Thanks and Regards,

Piyush 

 

  • BBIUser's avatar
    BBIUser
    Helper IV
    8 years ago

    Thanks Anonymous! It works.

     

    Since I am new to Power BI and only trying out POCs, it is good to know that there is an option 'Custom Column'.

    But can I know in what scenarios the 'custom column' and 'calculated column' should be used?

     

    Thanks again!