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.
Solved! Go to Solution.
You don't need the IF statements within SWITCH, try
Days for IV Approval =
SWITCH (
TRUE (),
ISBLANK ( [Ready for Treasury Approval] )
&& ISBLANK ( [Ready for Credit Approval] )
&& ISBLANK ( [Ready for Tax Approval] )
&& ISBLANK ( [Ready for Category Manager Approval] )
&& NOT ( ISBLANK ( [Submitted to Workflow] ) )
&& NOT ( ISBLANK ( [Ready for Independent Validation Approval] ) ), [Ready for Independent Validation Approval] - [Submitted to Workflow],
ISBLANK ( [Ready for Treasury Approval] )
&& ISBLANK ( [Ready for Credit Approval] )
&& ISBLANK ( [Ready for Tax Approval] )
&& NOT ( ISBLANK ( [Ready for Category Manager Approval] ) )
&& NOT ( ISBLANK ( [Ready for Independent Validation Approval] ) )
&& NOT ( ISBLANK ( [Submitted to Workflow] ) ),
[Ready for Independent Validation Approval] - [Ready for Category Manager Approval],
ISBLANK ( [Ready for Treasury Approval] )
&& ISBLANK ( [Ready for Credit Approval] )
&& NOT ( ISBLANK ( [Ready for Tax Approval] ) )
&& NOT ( ISBLANK ( [Ready for Independent Validation Approval] ) )
&& NOT ( ISBLANK ( [Submitted to Workflow] ) ), [Ready for Independent Validation Approval] - [Ready for Tax Approval],
ISBLANK ( [Ready for Treasury Approval] )
&& NOT ( ISBLANK ( [Ready for Credit Approval] ) )
&& NOT ( ISBLANK ( [Ready for Independent Validation Approval] ) )
&& NOT ( ISBLANK ( [Submitted to Workflow] ) ), [Ready for Independent Validation Approval] - [Ready for Credit Approval],
NOT ( ISBLANK ( [Ready for Treasury Approval] ) )
&& NOT ( ISBLANK ( [Ready for Independent Validation Approval] ) )
&& NOT ( ISBLANK ( [Submitted to Workflow] ) ), [Ready for Independent Validation Approval] - [Ready for Treasury Approval]
)
Thank you!
You don't need the IF statements within SWITCH, try
Days for IV Approval =
SWITCH (
TRUE (),
ISBLANK ( [Ready for Treasury Approval] )
&& ISBLANK ( [Ready for Credit Approval] )
&& ISBLANK ( [Ready for Tax Approval] )
&& ISBLANK ( [Ready for Category Manager Approval] )
&& NOT ( ISBLANK ( [Submitted to Workflow] ) )
&& NOT ( ISBLANK ( [Ready for Independent Validation Approval] ) ), [Ready for Independent Validation Approval] - [Submitted to Workflow],
ISBLANK ( [Ready for Treasury Approval] )
&& ISBLANK ( [Ready for Credit Approval] )
&& ISBLANK ( [Ready for Tax Approval] )
&& NOT ( ISBLANK ( [Ready for Category Manager Approval] ) )
&& NOT ( ISBLANK ( [Ready for Independent Validation Approval] ) )
&& NOT ( ISBLANK ( [Submitted to Workflow] ) ),
[Ready for Independent Validation Approval] - [Ready for Category Manager Approval],
ISBLANK ( [Ready for Treasury Approval] )
&& ISBLANK ( [Ready for Credit Approval] )
&& NOT ( ISBLANK ( [Ready for Tax Approval] ) )
&& NOT ( ISBLANK ( [Ready for Independent Validation Approval] ) )
&& NOT ( ISBLANK ( [Submitted to Workflow] ) ), [Ready for Independent Validation Approval] - [Ready for Tax Approval],
ISBLANK ( [Ready for Treasury Approval] )
&& NOT ( ISBLANK ( [Ready for Credit Approval] ) )
&& NOT ( ISBLANK ( [Ready for Independent Validation Approval] ) )
&& NOT ( ISBLANK ( [Submitted to Workflow] ) ), [Ready for Independent Validation Approval] - [Ready for Credit Approval],
NOT ( ISBLANK ( [Ready for Treasury Approval] ) )
&& NOT ( ISBLANK ( [Ready for Independent Validation Approval] ) )
&& NOT ( ISBLANK ( [Submitted to Workflow] ) ), [Ready for Independent Validation Approval] - [Ready for Treasury Approval]
)
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |