topic Re: Leadtime by customer ranking in DAX Commands and Tips

Leadtime by customer ranking

locle90 — Thu, 11 Aug 2022 08:31:35 GMT

Dear All,

I have a data with customer ranking,order,order leadtime.

I need to show a chart with 1 ranking 1 line and accumilation of order like picture bellow.

Could you help to give me your advice ?

Re: Leadtime by customer ranking

lbendlin — Sun, 14 Aug 2022 02:12:36 GMT

You need to indicate the order in which the values should appear. Power BI has no concept of row numbers, you need to provide that manually.

Please provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. Screenshots of your source data are not useful.

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Leadtime by customer ranking

locle90 — Mon, 15 Aug 2022 04:30:44 GMT

Dear Ibendlin,

Thanks for your advice,

I have the data with order date,ship date and customer ranking.

I need to no the order leadtime = ship date - order date and the chart of total order ( item) by customer ranking.

Please refe the data on my link.

Thanks in advance and have a nice day !

https://docs.google.com/spreadsheets/d/17b3dZlpPnvQH1f5hQ2-csU2SQLjc-9Be/edit?usp=sharing&ouid=103144787438833216419&rtpof=true&sd=true

Re: Leadtime by customer ranking

lbendlin — Mon, 15 Aug 2022 13:52:37 GMT

see attached

Re: Leadtime by customer ranking

locle90 — Tue, 16 Aug 2022 03:42:12 GMT

Dear Ibendlin,

Thanks for your support and your DAX almost done with my expectation.But i still have same problem with the days don't have the data.Please refer attach file and i have explaint on that.

https://drive.google.com/file/d/1P0CaYIJSbI287zobbdEFqCewEhcehzxT/view?usp=sharing

Re: Leadtime by customer ranking

lbendlin — Tue, 16 Aug 2022 13:19:02 GMT

In order to measure things that are not there you need to use disconnected tables. For example use GENERATESERIES(1,15) for the lead time buckets and then create a measure around it.

Re: Leadtime by customer ranking

locle90 — Wed, 17 Aug 2022 02:07:06 GMT

Dear Ibendlin,

Sorry but i don't get your point.Could you help a look on my file and explaint more ?

Have a nice day !

Re: Leadtime by customer ranking

lbendlin — Fri, 19 Aug 2022 22:58:02 GMT

see attached for a possible implementation