topic Re: Fill in blanks with the item's maximum lead time value in DAX Commands and Tips

Fill in blanks with the item's maximum lead time value

Anonymous — Mon, 12 Apr 2021 13:56:27 GMT

Hi experts,

Im trying to calculate the lead time for purchase orders (PO). Under each purchase orders are SKUs with their Order date and received date. For SKUs that havent been received yet, I want to show a SUGGESTED LEAD TIME (DAYS) where, suggested lead time (days) = their max lead time from all their previous POs. Thank you so much in advance for your help.

Here is a snapshot of what i am expecting:

Thank you!

Re: Fill in blanks with the item's maximum lead time value

Jihwan_Kim — Tue, 13 Apr 2021 06:29:13 GMT

Hi, Anonymous

please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

The dax measure is in the sample pbix file.

https://www.dropbox.com/s/5j2vdelh8vitsux/katvaldez.pbix?dl=0

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Re: Fill in blanks with the item's maximum lead time value

Anonymous — Tue, 13 Apr 2021 11:46:58 GMT

Hi Jihwan_Kim,

Thank you so much for taking the time to work on this. I greatly appreaciate it. Your solution worked, it is filling in blanks with the max lead time. However, when i apply a filter Status = Preparation, the suggested lead time (days) values are not showing.

Before filter

After applying filter

Re: Fill in blanks with the item's maximum lead time value

Anonymous — Thu, 15 Apr 2021 15:05:44 GMT

Hi Jihwan_Kim,

I converted your measure to a calculated column (Column = [Measure]) and it showed the values im looking for even after applying filters.

THANK YOU!