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

DSimma's avatar
DSimma
Icon for Advocate IV rankAdvocate 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
Icon for Post Patron rankPost 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
    Icon for Community Support rankCommunity 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

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

      Hi Qiuyun Yu,

       

      Thank you very much.