Forum Discussion

BBIUser's avatar
BBIUser
Icon for Helper IV rankHelper 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