joining
1 Topic
Full outer join 2 tables similar to a 1=1 repeating values from B onto A
I have 2 tables, A and B. I want to full outer join data from B onto A. In Sql, I know how I would do i.e. FULL OUTER JOIN B on 1=1. I'm looking for the same in DAX. Examples of A, B and Outcome below. A Item Desc 3870 pink hat 45783 blue scarf 5427 red dress 648 yellow gloves B Product Ctgry wearable Cotton wearable Poly wearable Rubber wearable Hemp Outcome Item Desc Product Ctgry 3870 pink hat wearable Cotton 3870 pink hat wearable Poly 3870 pink hat wearable Rubber 3870 pink hat wearable Hemp 45783 blue scarf wearable Cotton 45783 blue scarf wearable Poly 45783 blue scarf wearable Rubber 45783 blue scarf wearable Hemp 5427 red dress wearable Cotton 5427 red dress wearable Poly 5427 red dress wearable Rubber 5427 red dress wearable Hemp 648 yellow gloves wearable Cotton 648 yellow gloves wearable Poly 648 yellow gloves wearable Rubber 648 yellow gloves wearable HempSolved741Views0likes2Comments