Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Join two tables using between clause in Power BI

    Vote (14) 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

    Arunkumar Karingali 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.