Is it possible to create calculated columns using DAX functions in DirectQuery ?

[athuiraps]

Can we perform calucations using DAX if we use DirectQuery in Power BI New Version ?

We are working with two data sources in direct query mode and we are not able to create calculated columns based on the two tables from these two data sources.

REALTED, LOOKUPVALUE functions are not working..

[Anonymous · Accepted solution]

Hi @athuiraps ,

You can use DAX in DQ mode, but there are some restrictions. As you mentioned, the REALTED and LOOKUPVALUE functions are restricted. You can also refer to this link for specific restrictions.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ahmedoye]

Since Direct Query does not bring in a copy of the data into Power BI, there is no way to create Calculated Column in Power BI. Except you change your storage type to Dual. And then, you wouldn't be enjoying the full reasons for using Direct Query in the first place because your model will then still take time to refresh the copy of data it will keep in Power BI.

[Pragati11]

Hi @athuiraps ,

This is nothing to do with the Power BI version. DirectQuery mode has a limitation where you can't create a calculated column. See the link with official documentation: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about

Thanks,

Pragati