Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 UserCurrency which is measure
UserCurrency= LOOKUPVALUE(User[BaseCurrency],Users[UserId], USERNAME())
and calculated column like this which will fetch UnitValue from Exchange rate table based on User Currency.
ValueInBase = LOOKUPVALUE(ExchangeRate[UnitValue], ExchangeRate[Currency],[UserCurrency]) * Order[Value]
But it shows error that "Function 'LOOKUPVALUE' is not allowed as part of calculated column DAX expressions on DirectQuery models."
Please help.
Thanks!
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
Yes i agree with @dkay84_PowerBI his point.
but am not sure all the DAX function is supporting in Direct Query mode.because have some restriction in Direct Query mode.
Look the microsoft documentation in Power BI Site.
Thanks for your reply. I do have this enabled.
Is there any other way? Bascially I want dynamic value (calcualted based on exchnage rate ) for user (USERNAME()) to be applied.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
79 | |
63 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
100 | |
73 | |
67 |