Forum Discussion

User19's avatar
User19
Frequent Visitor
9 years ago

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...
Need Help
dkay84_PowerBI's avatar
dkay84_PowerBI
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago
DirectQuery limits the extent of DAX functions you can use by default. Advanced users can choose to bypass this limitation by selecting File > Options and then Settings > Options > DirectQuery, then selecting the option "Allow unrestricted measures in DirectQuery mode". When that option is selected, any DAX expression that is valid for a measure can be used. Users must be aware, however, that some expressions that perform very well when the data is imported may result in very slow queries to the backend source when in DirectQuery mode
  • User19's avatar
    User19
    Frequent Visitor
    9 years ago

    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.