Forum Discussion

android1's avatar
android1
Icon for Post Patron rankPost Patron
10 years ago
Solved

Custom Formula IF > 50

Hi,   i want to insert a new custom column if the vales contained in column Count Scheduled Hrs are > 50. I'm using =[Count Scheduled Hrs]>50 in a custom column formula but the results are FALSE. ...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi android1,

     

    In your scenario, you can create a new column based on the DAX function like below:


    = IF([Count Scheduled Hrs]>50,[Count Scheduled Hrs],BLANK())

     

    Please refer to the screenshot below:

     


    Reference:

    IF Function (DAX)


    If you have any question, please feel free to ask.

     

    Best regards,
    Qiuyun Yu

kcantor's avatar
kcantor
Icon for Community Champion rankCommunity Champion
10 years ago

DSimma is correct. You need to use the IF portion and you need to specify the return values. You could return something as simple as "Yes" or "No". After that, you can add that as a filter or slicer to your reports so that values only display when greater than or less than 50.