Custom Formula IF > 50

[android1]

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.

[kcantor]

@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.

[DSimma]

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]

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 · Accepted solution]

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]

Hi Qiuyun Yu,

Thank you very much.