Forum Discussion
Pulling one value from another table based on a set value in another column and between two dates
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/
Community ChampionI 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
- FarhanAhmed
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!!
