how to join tables

I have writen the sql query ...

SELECT
`a`.`Date` AS `Date`,
`b`.`UnitID` AS `UnitID`,
`b`.`IssueID` AS `IssueID`
FROM
(`sheet1` `a`
JOIN `Sheet3` `b`)
WHERE
((`a`.`Date` >= `b`.`Date Start`)
AND (`a`.`Date` <= `b`.`Date End`))

I just need this in Power BI language :(

My approach may not be the best, but here goes:

I would start with a merge as new query operation within the query editor.

You can perform all the select aspects after the merge (i.e. removing columns).

You join sheet2 and sheet3 on Unit ID, choosing the appropriate type of join.

Once you have this new merged query, merge it (as new query) with the sheet1 table using DateStart and Date as the fields, and choose the appropriate join type to return all rows from the fact table with only the matching rows from the date table.

Repeat this process, using the original merged query, but use the DateEnd field.

Append the two final merged tables (date start and date end).

Remove the columns you don't need.