Forum Discussion
Solved
Appending selected columns - recreating DAX in M
Hi all,
i have simple dax formula to create a DimAccount table. As I am not very good with M i would liek to ask you what should I put into blank Query to get the same result as by DAX:
DimAccount =
DISTINCT(
union(
SUMMARIZE(Src1,Src1[Account],Src1[A])
,SUMMARIZE(Src2,Src2[Account],Src2[F])
)
)
Thank you in advance
Kind regards
=Table.Distinct(Src1[[Account],[A]]&Src2[[Acount],[F]])
2 Replies
=Table.Distinct(Src1[[Account],[A]]&Src2[[Acount],[F]])
Thx a lot, it helped 🙂
But at the first run it returned error because of Account spelling in Src2 😉 it is not an issue as this are data from dummy model 🙂
