Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi,
I'm using a calculated column to do in an SLA process, but due to the processes in each area, this SLA must be flexible. So I created a what if, but I need to turn this column rule into DAX, any help?
DAYS REQUEST>ORDER=
IF('3TB_REQUEST'[DATA_ORDER]>=0.1,
IF('3TB_REQUEST'[DATA_APPROVAL]>=0.1,
NETWORKDAYS('3TB_REQUEST'[DATA_APPROVAL],'3TB_REQUEST'[DATA_ORDER]),
NETWORKDAYS('3TB_REQUEST '[DATA_REQUEST],'3TB_REQUEST'[DATA_ORDER])))
This is already in DAX. What is your issue with this formula (apart from the missing outer "else")?
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.