Join two tables using between clause in Power BI

[ajaya_sahoo]

We have two tables A and B. We need to join in such a way that A.COL1 = B.COL1 AND A.COL2 between B.COL2 AND B.COL3 where A.COL2 is a date key and B.COL2 and B.COL3 are dates.

[fbcideas_migusr]

IF we could include what kind of join operation need perform , like Loading Table a and Table B Table A ---Inner/left/outer/Full/cross Joins ----Table B with selection of on conditions.