Replace values in column if two criteria are met

[android1]

Hi,

I'm looking to create a new calculated column Real Act Min. This will contain the vaues of column actualMinutes but if the values in actualMinutes *1.5 are greater than the corresponding values in column scheduledMinutes then the values in Real Act Min should = scheduledMinutes

Trying this with no luck -> Real Act Min = IF([actualMinutes]>[scheduledMinutes]&&[actualMinutes]*1.5 >[scheduledMinutes],[scheduledMinutes])

[Habib · Accepted solution]

Hi @android1

What i understood from your statement, your formula should be like this and it should work. Sample is the table name of your table.

Real Act Min = IF('Sample'[actualMinutes]*1.5>'Sample'[scheduledMinutes ],'Sample'[scheduledMinutes ],'Sample'[actualMinutes])

[Habib · Accepted solution]

Hi @android1

What i understood from your statement, your formula should be like this and it should work. Sample is the table name of your table.

Real Act Min = IF('Sample'[actualMinutes]*1.5>'Sample'[scheduledMinutes ],'Sample'[scheduledMinutes ],'Sample'[actualMinutes])

[android1]

That's great Habib, works perfectly.

Thank you.

[android1]

I forgot one other thing. How would I amend this to incl the condition that if actualMinutes  < scheduledMinutes then Real Act Min = actualMinutes.

[Habib]

It can be included but what will be the else part. I mean what will be output of both conditions are false?

[android1]

Hi Habib,

Output should be actualMinutes if both are false.

[Habib · Accepted solution]

Try this one.

Real Act Min = IF('Sample'[actualMinutes]>'Sample'[scheduledMinutes ] && 'Sample'[actualMinutes]*1.5>'Sample'[scheduledMinutes ],'Sample'[scheduledMinutes ],'Sample'[actualMinutes])