I am trying to calculate and visualize our supplier lead time. I want to see if the actual lead time we have stated is accurate. The problem is that I am stuck in how to even begin. I can calculate lead time between ordering date and receiving date, but then what? We have hundreds of orders placed every month from different suppliers and I want to be able to see how many of those were received on time, how many were late (exact number of days late) and how many were early (also exact days). The purpose is to tweek our erp lead time so that they match with reality.
I forgot to mention that I cannot create any columns as I am restricted only to the modelling tab and the reporting tab. This is due to that the storage mode is direct query. So the solution can only include measures and not calculated columns. Also your soloution only gives me a true or false if late/early, correct? I need to calculate the exact lead times, not only early/late.
Can you assist with the measure as well? I am not able to create any measures in direct query due to restrictions. I can only access the dataset as is and create measures afterwards. Same with query editor, no access.