Forum Discussion

leemsiska's avatar
leemsiska
Microsoft Employee
4 years ago

Merge tables based on date range

Hello,    A bit stuck and confused with the table merge process. I have two tables, Date Range, which has my daily date range of when a job should be executed on a particular day, and with that I h...
Need Help
leemsiska's avatar
leemsiska
Microsoft Employee
4 years ago

Hi Anonymous

 

Thanks for responding to the request for help. I followed your steps and did not quite resolve the issue. Partly this is due to my fault as I did not present the scenario exactly as my actual data set. In the example I shared earlier, this assumes a 1:1 match between the two tables. In actual fact, table on the left (Date Range) has more records than the execution table, as this could be due to the job missing from schedule. My data set has 376 records on left and 151 on right table 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi leemsiska ,

 

I believe Merge can complete your operation. Merge also has several join types you can choose to try.

About join types, you can refer to

Choose the Right Merge Join Type in Power BI

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.