Forum Discussion
dynamic exchange rate
Hi, I am looking to create a Calculated Column in Power BI Embedded, that will have values in currency user has selected as his base currency in appliacation. So, I have created a UserCurrenc...
Hi User19,
In direct query mode there are some limitation to directly calculate the result value. Perhaps you can try to use import mode or calculate the result at query editor.(But I haven't found usename functions in power query)
Reference link:
DAX Formula Compatibility in DirectQuery Mode (SSAS 2016)
Regards,
Xiaoxin Sheng
AnonymousThanks. However import is not an option.