Forum Discussion
woshi_eads
2 years agoHelper I
split data automatically via dax
Hi Team,
I have two tables as picture, 1 & 2 as the datta source.
and in the right, it should be the output.
how to achieve that in power bi desktop?
2 Replies
- amitchandakSuper User
woshi_eads , To me seem like append in Power query and Union in DAX
Append Tables (Power Query)
https://www.youtube.com/watch?v=KyXIDInZMxk&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=15 - ryan_mayuSuper User
what's the calculation logic of qty column?