Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
The report was designed to showcase the On Time In Full (OTIF) status of all orders for the past two years.
Each shipment is assessed on two criteria:
1) If the full quantity was shipped
2) If the order was shipped on the Due Date
The report has an Allowable Window, where a Customer might be able to accept shipments upto sixty day early or late.
Once a user has selected the Allowable Window, the
rest of the report will use this window to calculate the OTIF status.
The Trend Buttons allow users to investigate through the report without having to leave the report page and keeping any applied filters.
The Columns, Parameters and DAX:
There is one additional column, two parameters and a host of measures.
Days - the only column
The data has columns Due Date and Ship Date, therefore we can use DATEDIFF to calculate the difference in the two dates. I use a column for this.
The Early and Late Parameters are set up as Whole Number, and they automatically generate measures: Early Value and Late Value. We use these as the allowable window.
The Measures
With these three pieces of information we can work out if an order was delivered In Full and On Time, including any user entered Allowable Window:
On Time Shipment
To count as an on time shipment, the order must be In Full and the days difference must be less than the allowable early and the allowable late. We will count the number of rows on the OTIF table to fit these criteria.
Early Shipments
These are one criteria easier than On Time, if the Days is greater than the allowable early and it's In Full, then the shipment was early:
eyJrIjoiNmIwYjAxZmEtMzE4OC00MDExLTlhYjAtM2FiMmMyMWQxNzUxIiwidCI6ImM3ZWE5NDI0LWNkZWMtNGE5Zi1iYzljLWE3MDkwOTMwNjk0NCJ9
Dear Sir/Madam,
I hope this message finds you well.
I am writing to express my interest in the OTIF report template you have developed, which I found to be exceptional. I would greatly appreciate it if you could share a soft copy of this template with me.
Thank you in advance for your assistance.
Prefect !
Able to share the POWER BI Work as well?
Thank
i also need the source data and the Power BI output .... my email id is bheemisetty.santosh@gmail.com
Hi, is it possible to get the file?
hi,
great job with this one.
how could i get the power bi file?
thank you
Morning.
Is there anyway of getting this OTIF report please, or just the code behind so i can create my own?
Thanks Darren.
Great Work!! Is there any possibility to get the template?
Regards
OTIF
Hi,
I would like to know the DAX for STATUS part.
how do you use allowable window value.
Hi, please share the report with me?
Can I get a copy of this template?
hello, is it possible if i could have a copy of the report please so i can understand it better.
Can I have the report please ? I have a project to show OTIF Performance and I need it !
Thank you !
Hi,
Great report. Gave me some ideas to implement in my organization
Question: How to create this "mini windowed" visualizations like below?
It's some kind of use of drill trought?
That's a Tooltip page.
The page only has that graph on it. You just need to add a new page, set it as a Tool tip and then from the original graph, you can choose to use the specific tool tip page.
Hi Andy100Rob, thanks for sharing and I've spent a lot of time trying to achieve a new OTIF report at work that unfortunately, does not look anywhere near as nice as the one you have created.
Can I be cheeky and ask if you could share the file with me so I can try and use it for my data?
Thanks a million
Can you please share dataset for the dashboard, I will like to use it for some other portfolio project
Thanks
This is indeed very helpful. I could complete my OTD report in couple of hours with above mentioned reference Dax. Interested in seeing more KPIs like these related to supply chain..
Hello,
Sorry, I'm new here.
I love this and it's perfect for what I'd like to use, is it possible to download it with the data so I can use it, or is this protected?
Sorry for the dim question, I'm new to Power BI.
Thanks again
Great report. I was having a hard time trying to desing an OTIF report for my organization until I came accross this post. Thanks for sharing!
I'm stil interested in getting the report...