Forum Discussion
Solved
Is it possible to create calculated columns using DAX functions in DirectQuery ?
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 bas...
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.
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.