How can i write this logic in DAX

[Anonymous]

i am trying to recreate this column using DAX based in this power query logic but cant find the right syntax. anyone with a good suggestion?

= Table.AddColumn(#"Filtered Rows", "RadioButton", each if((Date.From([START_DATE]) <>"" ) and (Date.From(END_DATE]) = "") or
(Date.From([START_DATE]) <= Date.AddDays(Date.From(DateTime.LocalNow()),3))) then "3 Forward" else if (Date.From([FINISH_DATE]) >= Date.AddDays(Date.From(DateTime.LocalNow()),7)) then "7 Forward" else null)

[v-yadongf-msft · Accepted solution]

Hi @Anonymous ,

Please try to use SWITCH function:

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"
      )

If it doesn't work, can you share with me some screenshots of your data after hiding sensitive information and tell me what's your expected output?

Best regards,

Yadong Fang

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

[v-yadongf-msft · Accepted solution]

Hi @Anonymous ,

Please try to use SWITCH function:

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"
      )

If it doesn't work, can you share with me some screenshots of your data after hiding sensitive information and tell me what's your expected output?

Best regards,

Yadong Fang

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

[Anonymous]

Here is my new column logic but its giving me an error at the end of the code

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"

[Ashish_Mathur · Accepted solution]

Hi,

Try this calculated column formula

NewColumn = IF((NOT(ISBLANK('Tasks'[ACT_START_DATE]))&&ISBLANK('Tasks'[ACT_END_DATE]))|| 'Tasks'[ACT_START_DATE]<= TODAY()+3,"3 Forward",if('Tasks'[ACT_START_DATE]<=today()+7,"7 Forward",BLANK()))

Hope this helps.