Forum Discussion
Helper INeither M or DaX formulas recognised
As mentioned above, you could convert the record into a table and then add to data model. That way, you may use DAX to add a calculated column.
Community ChampionIt looks to me that you are trying to use DAX expressions where you should be using Power Query "M" Code. You could import the data into your data model and then create the custom columns/measures using the DAX that you have. But you need to do that in your data model in Excel and not in Power Query editor. See this article:
https://community.powerbi.com/t5/Community-Blog/The-Languages-of-Power-BI/ba-p/69104
dyingodHello! Thanks for this.
I tried both M and DaX, same issue.
Is there another way I could import the exchange rate API, which is a tiny URL, directly into the custom column formula? Rather than creating it as a separate table/list/query in itself?
Here are some screenshots if this helps?latest attempt using MVK is the table I want to import exchange rate toRUB2GBP is the query with exchange rate
v-chuncz-msftCommunity Support
You may combine the two queries in Advanced Editor, and add custom column as follows.
Record.Field(Source2, "RUB")
- dyingod
Thanks v-chuncz-msft!
Is that the only way? seems a shame to screw up a nicely modelled table with a weird single-value column but yeah if that is what it takes then yes pls! :)