Solved: Re: Can I use the same DAX expressions/formulas in...

Anonymous · ‎04-28-2020

If I have the same models (tabular) made in Power BI desktop and SSAS, can I use the same DAX expressions/formulas to create measures?

For example, I create model_a in Power BI desktop and model_b (tabluar) in SSAS; the both models have the same tables, columns, and relationsships. Can I use the same DAX expressions/formulas to in Power BI desktop and SSAS for creating the same measures?

If yes, DAX syntaxes are the same?

Wimverh · ‎04-28-2020

In general I would say yes. Both use the vertipaq engine, so the same dax code works between
power bi desktop and SSAS tabular.

Power BI desktop gets a monthly update, SSAS tabular updates are not so frequent, and
depending of the version (SSAS 2016,2019,...)

You can check the website daxguide
The coalesce function is only available in tabular 2019 and not in earlier releases:

dax guide coalesce function

View solution in original post

Wimverh · ‎04-28-2020

In general I would say yes. Both use the vertipaq engine, so the same dax code works between
power bi desktop and SSAS tabular.

Power BI desktop gets a monthly update, SSAS tabular updates are not so frequent, and
depending of the version (SSAS 2016,2019,...)

You can check the website daxguide
The coalesce function is only available in tabular 2019 and not in earlier releases:

dax guide coalesce function