Post reply

Left Outer Join in SSAS Tabular

  • May 5, 2016 at 11:32 am

    #326902

    Maybe this is a silly question, but I haven't found the answer yet. I want to bring separate tables into SSAS Tabular and then join them using LEFT OUTER JOIN. How is this done? I know you can go to diagram view and graphically join tables, but I don't see any options for INNER or OUTER joins.

    So, how is this done in Tabular? I'm using SSAS 2014.

  • May 5, 2016 at 1:37 pm

    #1876969

    This may help: https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/[/url]

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply