locked
Left Join Azure Analysis tabular model RRS feed

  • Question

  • Hi, 

     We have a requirement having 5 dimensions tables and 1 Fact table.We need to join Fact Table Left outer to 5 Dimension tables.Please let us know how to do in Azure analysis tabular model.

    Regards,

    Suman.

    Wednesday, February 19, 2020 7:50 AM

All replies

  • Hello Suman , 

    I bit more context with some dummy data could have helped the community to get to the query . But I think You should try out something 

    SELECT 
      Id, adm.Name,dep.something
    FROM 
      fct
    LEFT JOIN dim as adm
      ON fct.Arrival_location = adm.LocationID
    LEFT JOIN dim as dep
      ON fct.Departing_location = dep.LocationID

    ** I will not suggest you use too many left join( it depends upon the data ) , but this should help you give the kick start . 


    Thanks Himanshu

    Friday, February 21, 2020 8:32 PM