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.
Helper IHello! 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
Community 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! :)
- v-chuncz-msft
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.