It’s been some days that i’m trying to calculate some KPIs on processing client orders.
I have this table:
And I have to calculate if I acomplish the time stablished. My objective is:
Every order recieved before 13:00, must be finished same day before 23:59.
Every order recieved after 13:00, must be finished next day before 23:59.
i’ve tried to find aDAX formula, but won’t be able , and even tried it to calculate it using custom columns, but either.
Please can anyone help me with that?
Thank you so much!!!