Forum Discussion
SQL OUTER APPLY - DAX equivalent?
in dax relationships you can create a variety of relationships
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
as well as power query there are a variety of join methods
http://radacad.com/how-to-change-joining-types-in-power-bi-and-power-query
yes, i googled this question before posting. both articles are two years old, so uncertainty remains about outer apply.
hxkresl have you attempted anything? outer apply being an outer join. in power query the article see below
even if the articles are 2 years old the technology hasn't changed that drastically, ie. im unclear what you are looking for? why dont you post your sql statement
from the power query article
vanessafvg can you show example of OUTER APPLY in DAX (not power query)please? I simply don't know how to start it and am looking for tutorial.
there is this
https://msdn.microsoft.com/en-us/library/dn802527.aspx
but ive never used it before and im not sure it does outer apply, personally i have not used any join type syntax in dax the way i would sql.
being a sql person for 20+ years i can say that there is a mind shift involved in engaging with DAX so sometimes trying to apply the same logic will have you chasing your own tail. Power Query is also there to make the shaping of data really easy so try it too if it makes sense. Get the data into the shape you want it and then using dax to do more calculations than transformations is probably the best way to go.
