Forum Discussion
SQL OUTER APPLY - DAX equivalent?
yes, i googled this question before posting. both articles are two years old, so uncertainty remains about outer apply.
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.
