Forum Discussion
Advocate IDAX Functions - Level of Support
OK, you seem to be confusing DAX and Power Query "M". DAX is not used in Power Query. Power Query is "M" code as defined here:
https://msdn.microsoft.com/library/Mt253322?ui=en-US&rs=en-US&ad=US&f=255&MSPPError=-2147217396
This is for the queries that get data into your data model. Think SSIS.
Once your data is in your data model, then you use DAX to create new columns and measures.
Think MDX for SSAS.
You wouldn't try using MDX in an SSIS package and similarly you wouldn't try to use DAX in Power Query "M".
Hope this clears things up.
Community ChampionOK, you seem to be confusing DAX and Power Query "M". DAX is not used in Power Query. Power Query is "M" code as defined here:
https://msdn.microsoft.com/library/Mt253322?ui=en-US&rs=en-US&ad=US&f=255&MSPPError=-2147217396
This is for the queries that get data into your data model. Think SSIS.
Once your data is in your data model, then you use DAX to create new columns and measures.
Think MDX for SSAS.
You wouldn't try using MDX in an SSIS package and similarly you wouldn't try to use DAX in Power Query "M".
Hope this clears things up.
Advocate IMakes perfect sense now, thanks!