Forum Discussion
Calculate and visualize lead time
Hi all,
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.
Sorry for this insufficient information.
Thanks.
4 Replies
Clay82 , there need to be three dates or you can check based on lead time.
If they are column in the same table
New column =
var _diff = datediff( [ordering date],[receiving date], day)
//assume 2 days
return
Switch(true() ,
_diff< 2, "Early",
_diff =2, "On Time" ,
"Late"
)
Thanks for your suggestion!
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.
Clay82 , you need to do bucketing based on measure
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-kdatediff in direct query
