Forum Discussion

android1's avatar
android1
Post 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

5 Replies

  • DSimma's avatar
    DSimma
    Advocate IV
    10 years ago

    You need to us an if statement

     

    Like

     

    =if([Count Scheduled Hrs]>50,">50","<50")

     

    So that if greater then 50 it displays ">50" and if not it displays "<50"

    • android1's avatar
      android1
      Post Patron
      10 years ago

      Thanks. I would like the custom column to actually contain the values of [Count Scheduled Hrs]. So if [Count Scheduled Hrs]

      contains 40,55,60, then custom column should be 55 & 60.

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Community Support
        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
    Community 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.