Forum Discussion
Generate rows??? Creating daily data from 2 date ranges
Reaching out to the PBI family to see if you can help me through this problem.
First, I have a dynamic date table that gives me a range of dates.
Secondly, I have on order table that lists order number, order date and it's original intended delivery date.
Thirdly, I have a delivery table that lists order number and arrival date.
--Lastly, I have a missed delivery reason table that lists order number and reason for missed delivery.
The need is to report a missed delivery daily until the order finally arrives. So, if the original intended delivery date doesn't match the arrival date, rows need to generate for the missed days until arrival.
Any suggestions on how to tackle this would be greatly appreciated!!
Hi unknown917
I have used some sample data based on your requirement.
Can you please check the pbix file which i have created and let us know is that work for you scenario or not.
I have merged the table in power query editor.
If this answers your questions, kindly accept it as a solution and give kudos.
4 Replies
Hi unknown917
I have used some sample data based on your requirement.
Can you please check the pbix file which i have created and let us know is that work for you scenario or not.
I have merged the table in power query editor.
If this answers your questions, kindly accept it as a solution and give kudos.Please define "daily". Is that always TODAY() ?
Hi unknown917 ,
Thank you mdaatifraza5556 for the inputs.We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.
Best Regards,
Chaithra E.Hi unknown917 ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help assist you.
Thank you.
