https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Kpis-Logistics-Outbound-Delivery-Dax/m-p/1225796#M19954 <P>File</P><P><A href="https://drive.google.com/file/d/1tSpCtPPLyYef7jJFJZI_0fK9HuubMcqR/view?usp=drivesdk" target="_blank">https://drive.google.com/file/d/1tSpCtPPLyYef7jJFJZI_0fK9HuubMcqR/view?usp=drivesdk</A></P> Wed, 15 Jul 2020 19:43:51 GMT Yrstruly1 2020-07-15T19:43:51Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Kpis-Logistics-Outbound-Delivery-Dax/m-p/1223885#M19893 <DIV class="Ls"><DIV class="As"><P>&nbsp;</P></DIV></DIV><DIV class=" Xg "><DIV class="Zg"><DIV class="Rg"><DIV class="Li"><DIV class="yj"><DIV class="Ph"><DIV class="yh "><DIV class="Vh"><DIV class="aj"><DIV class="Ni"><DIV class="ni pi "><DIV><DIV>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?</DIV><DIV>&nbsp;</DIV><DIV>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?</DIV><DIV>&nbsp;</DIV><DIV>Kpis:</DIV><DIV>Time, orders delivered vs orders promised.</DIV><DIV>Location</DIV><DIV>FailedDeliveredOrders etc.</DIV><DIV>&nbsp;</DIV><DIV>Any dax formulas you would use, please advise?</DIV><DIV>&nbsp;</DIV><DIV>Do you know why powerbi is not displaying certain column data in the data view of a excel source?</DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV> Wed, 15 Jul 2020 07:59:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Kpis-Logistics-Outbound-Delivery-Dax/m-p/1223885#M19893 Yrstruly1 2020-07-15T07:59:14Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Kpis-Logistics-Outbound-Delivery-Dax/m-p/1223910#M19895 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="244745" data-lia-user-login="Yrstruly1" class="lia-mention lia-mention-user">Yrstruly1</a>&nbsp;</P><P>&nbsp;</P><P>You can check these links</P><P>&nbsp;</P><P><A href="https://www.youtube.com/watch?v=QZVVd3IzS1k" target="_blank">https://www.youtube.com/watch?v=QZVVd3IzS1k</A></P><P><A href="https://www.youtube.com/watch?v=zppeQPUdZDM" target="_blank">https://www.youtube.com/watch?v=zppeQPUdZDM</A></P><P><A href="https://www.youtube.com/watch?v=-Wx9Tm-g_a0" target="_blank">https://www.youtube.com/watch?v=-Wx9Tm-g_a0</A></P><P>&nbsp;</P><P><A href="https://powerbi.microsoft.com/en-us/partner-showcase/managility-pty-ltd-logistics-insights-and-optimization/" target="_blank">https://powerbi.microsoft.com/en-us/partner-showcase/managility-pty-ltd-logistics-insights-and-optimization/</A></P><P><A href="https://powerbi.microsoft.com/en-us/partner-showcase/enterprisedna-transportation/" target="_blank">https://powerbi.microsoft.com/en-us/partner-showcase/enterprisedna-transportation/</A></P><P>&nbsp;</P><P><BR />Regards,</P><P>Harsh Nathani</P><P><BR /><STRONG>Appreciate with a Kudos!! (Click the Thumbs Up Button)</STRONG></P><P><STRONG>Did I answer your question? Mark my post as a solution!</STRONG></P><P>&nbsp;</P><P>&nbsp;</P> Wed, 15 Jul 2020 08:05:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Kpis-Logistics-Outbound-Delivery-Dax/m-p/1223910#M19895 Anonymous 2020-07-15T08:05:10Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Kpis-Logistics-Outbound-Delivery-Dax/m-p/1223940#M19896 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="244745" data-lia-user-login="Yrstruly1" class="lia-mention lia-mention-user">Yrstruly1</a> , there are two dates. create a common date table and join with that. And use userelation to choose table. </P> <P>&nbsp;</P> <P><A href="https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970" target="_blank">https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970</A></P> Wed, 15 Jul 2020 08:17:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Kpis-Logistics-Outbound-Delivery-Dax/m-p/1223940#M19896 amitchandak 2020-07-15T08:17:10Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Kpis-Logistics-Outbound-Delivery-Dax/m-p/1225796#M19954 <P>File</P><P><A href="https://drive.google.com/file/d/1tSpCtPPLyYef7jJFJZI_0fK9HuubMcqR/view?usp=drivesdk" target="_blank">https://drive.google.com/file/d/1tSpCtPPLyYef7jJFJZI_0fK9HuubMcqR/view?usp=drivesdk</A></P> Wed, 15 Jul 2020 19:43:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Kpis-Logistics-Outbound-Delivery-Dax/m-p/1225796#M19954 Yrstruly1 2020-07-15T19:43:51Z