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")
     
Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

How would you calculate Top/Bottom on this dataset?  Please explain and show the expected result.