Forum Discussion
Solved
Append tables with same columns using DAX
Hi friends! Basically is that, i want to merge or append tables that has the same columns (same quantity and same name) using DAX. I know how to do it in Power Query but I read on a post that DAX...
Hi AlexisKMX ,
Please try below dax function:
UNION: same as the append feature in Power Query
NATURALINNERJOIN/NATURALLEFTOUTERJOIN: same as the merge feature in Power Query
For more details, you can read related document:
UNION function (DAX) - DAX | Microsoft Learn, UNION – DAX Guide
NATURALINNERJOIN function (DAX) - DAX | Microsoft Learn , NATURALLEFTOUTERJOIN function (DAX) - DAX | Microsoft Learn
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Padycosmos
Solution Sage
Solution SageHope this video helps: