Need help rewriting this in DAX.

[Anonymous]

i get an error saying i have too many arguments. any  one able to tell me where i am going wrong?

NewColumn = IF (

    ( NOT ( ISBLANK ( 'Tasks'[ACT_START_DATE] ) ) && ISBLANK ( 'Tasks'[ACT_END_DATE] ) )

        || 'Tasks'[ACT_START_DATE]

            <= TODAY () + 3, "3 Forward",

    'Tasks'[ACT_END_DATE] +7,  "7 Forward")  

[hnguy71 · Accepted solution]

@Anonymous What's the logic you need?

[Fowmy]

@Anonymous 

I would use SWITCH to make it readable 

NewColumn =
SWITCH (
    TRUE (),
    (
        (
            NOT ( ISBLANK ( 'Tasks'[ACT_START_DATE] ) ) && ISBLANK ( 'Tasks'[ACT_END_DATE] )
        )
            || (
                'Tasks'[ACT_START_DATE]
                    <= TODAY () + 3
            )
    ), "3 Forward",
    'Tasks'[ACT_END_DATE] + 7, "7 Forward"
)

[mangaus1111 · Accepted solution]

For example

NewColumn =  SWITCH ( TRUE(),
                    ( NOT ( ISBLANK ( 'Tasks'[ACT_START_DATE] ) ) && ISBLANK ( 'Tasks'[ACT_END_DATE] ) ) || 'Tasks'[ACT_START_DATE]<= TODAY () + 3, "3 Forward",
                     MAX('Tasks'[ACT_START_DATE]) <= TODAY () + 7,  "7 Forward" 
                   )

[mangaus1111]

Hi @Anonymous ,

the IF function accept maximum 3 arguments and you have used 4.

Try to use SWITCH instead.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[hnguy71 · Accepted solution]

@Anonymous What's the logic you need?