topic Re: Adding an if statement to this code in DAX Commands and Tips

Adding an if statement to this code

Anonymous — Tue, 02 Jul 2024 19:33:37 GMT

Hello,

I am trying to add an if statement to the code below. The if needs to be "if less than 40, make the output = to 40". Here is the code:

Weekly Hours Worked = CALCULATE(

SUMX(Timesheet,[Hours]),

FILTER(

'Timsheet',

'Timesheet'[Resource Name] = EARLIER('Timesheet'[Resource Name]) && 'Timesheet'[Period Starting] = EARLIER('Timesheet'[Period Starting])

)

Thanks!

Irwan — Tue, 02 Jul 2024 23:51:25 GMT

Hello Anonymous

you can try using variable (direct conditional if should be worked as well but the DAX line would be quite long).

Weekly Hours Worked =

var _hours =

CALCULATE(

SUMX(Timesheet,[Hours]),

FILTER(

'Timsheet',

'Timesheet'[Resource Name] = EARLIER('Timesheet'[Resource Name]) && 'Timesheet'[Period Starting] = EARLIER('Timesheet'[Period Starting])

)

Return

IF(

_hours<40,

)

Hope this will help.

Thank you.