Skip to main content

Power BI

New

Join two tables using between clause in Power BI

Vote (7) Share
Power BI User's profile image

Power BI User on 03 Jun 2020 17:53:49

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.

Comments (1)
Power BI User's profile image Profile Picture

b6943b8a a825-ea11-a810-000d3a8f004f on 06 Jul 2020 00:15:29

RE: Join two tables using between clause in Power BI

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.