Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Solved! Go to 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.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |