Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

bottom 10%

Hello Community,   I have a very simple dataset showing a dealer's customer satisfaction score %.  Once the data is imported into PowerBI, how can I create a new column that will auto-populate "yes...
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    Hi Anonymous 

    Here is the formula, change the rate as you wish

    Yes or No =
    var DealerScore = Sheet1[Customer Satisfaction]
    Return
    IF( DealerScore < 0.5 , "Yes", "No")
     
aj1973's avatar
aj1973
Community Champion
5 years ago

Hi Anonymous 

Here is the formula, change the rate as you wish

Yes or No =
var DealerScore = Sheet1[Customer Satisfaction]
Return
IF( DealerScore < 0.5 , "Yes", "No")