Forum Discussion
Solved
Pulling one value from another table based on a set value in another column and between two dates
Hey, i have two tables, one a standard calendar table and the other with varying data in it including a 'dates from' and a 'dates to' column, see image below. I need to pull the 'target da...
I think you can do it by
1- create a duplicate table of Drilliing Table
2- Filter it to Underground
3- Create a New column "{[Date From]..[Date To]}"
4- Expand this column to Rows
5- Merge this table with your calender or use same table (in this case you dont need calendar table because list of dates already created.)
Ref: https://www.poweredsolutions.co/2019/07/23/fill-dates-between-dates-with-power-bi-power-query/
Thank you for that! It does what i need it too! Much appreciated
Great to hear that.
Can you please Mark my post as a solution so that other members can benefit from it.
Appreciate your Kudos too!!