Forum Discussion
How to convert the below dax to m query
Sample file : https://drive.google.com/file/d/1esnAxQh7DVS4UKpkp6C4h0S3FR2KnA8p/view?usp=sharing Lookup = CALCULATE(FIRSTNONBLANK('Table B'[Category],1),FILTER('Table B','Table B'[Concat]=...
Hi Anonymous ，
It depends,in your case,I would suggest calcualted columns.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
daxer-almighty
Solution Sage
Solution SageThrough INNER or LEFT OUTER JOIN. This can be done using the Merge operation.
But how to add multiple conditions
- daxer-almighty
Joins in Power Query can be done on an arbitrary number of columns.
How?
- daxer-almighty
Here's a vid that explains the type of joins: https://youtu.be/PNdxy0c1Shg
Here's a vid about joins in Power Query: https://youtu.be/BV3srtI20Bo
Here's something about programming in Power Query's language called M: https://youtu.be/mXbjoSg9ldo