Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
@Anonymous What's the logic you need?
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"
)
@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"
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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"
)
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.
@Anonymous What's the logic you need?
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |