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 

     

EllaGen's avatar
EllaGen
New Member
4 years ago

hi i want to do a case statement in powerbi that is coming from a culculated measure in Power bi , how do i do this

Numbers% = sum(Query1[NuberPas])/sum(Query1[AllAssessed]) > this is the calculated measure but i want to do a calculated measure with this calculation 
 
 
New Calculated meature from top 1
Case when Numbers% = 100 then 1 else 0 end as NumberPositive

 

 

thanking you in advance