Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How can i write this logic in DAX

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)

Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    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.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago
    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's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      3 years ago

      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.

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    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.