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
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi leemsiska ,

 

According to your description, I did the following

 

1.Merge two tables

 

2.Add a custom column named Job Not Triggered in Range.

 

3.Add a conditional column named SLA Breach.

 

Result:

 

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.

  • 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.