Forum Discussion
SQL OUTER APPLY - DAX equivalent?
I will need to convert a SQL statement that takes a base dataset and OUTER APPLYs it to a Date table, to cause the right-side query (Date) to execute once per result in the left-side query (base data...
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