Kpis Logistics, Outbound Delivery. Dax

[Yrstruly1]

I'm creating a dashboard with the data attached. Its for a distribution assignment. I googled kpis for logistics etc. I would like to know is there any tips you can give me that i might be missing or neclect. Also, how would you join these tables?

There is a connection in two of the 3 tables, which powerbi and tableau detected. The other one i created an i.d field in both and joined them, would you say that's suffice?

Kpis:

Time, orders delivered vs orders promised.

Location

FailedDeliveredOrders etc.

Any dax formulas you would use, please advise?

Do you know why powerbi is not displaying certain column data in the data view of a excel source?

[amitchandak]

@Yrstruly1 , there are two dates. create a common date table and join with that. And use userelation to choose table.

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[Yrstruly1]

File

https://drive.google.com/file/d/1tSpCtPPLyYef7jJFJZI_0fK9HuubMcqR/view?usp=drivesdk

[harshnathani]

Hi @Yrstruly1 

You can check these links

https://www.youtube.com/watch?v=QZVVd3IzS1k

https://www.youtube.com/watch?v=zppeQPUdZDM

https://www.youtube.com/watch?v=-Wx9Tm-g_a0

https://powerbi.microsoft.com/en-us/partner-showcase/managility-pty-ltd-logistics-insights-and-optim...

https://powerbi.microsoft.com/en-us/partner-showcase/enterprisedna-transportation/

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!