Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
No, you can't do that because DAX-constructed tables are calculated after the query refresh completes. But why not just do the join in the query editor in the first place? The Merge button is perfectly capable of outer joins.
Proud to be a Super User!
Hi @jamesjose23,
No, it's not possible. As KHorseman said, DAX-constructed tables are calculated after the query refresh completes. Any calculation in DAX won't be recognized in M query.
Regards,
Yuliana Gu
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |