Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
kris10me
New Member

Currency Converter

I am creating a dataflow that should pull updated conversion rates every day when it refreshes.  I created a function with the API information that looks like this:  

kris10me_0-1693337727456.png

Then created a query like this:

let
  Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("VZZRjqMwEETvMt97CRIYE7CBsXEIrPb+11iNS5SqvqInm3bTtDvv79+voeavP1+19F///vz96r4XpRiF+qsXOsquO9dO6PPUnV0uSsnWjqBUbe3SXB5F1x6jUa+5PB62dloUe4fP+q1rltljt+fWh1D1XLqkdGxKWSv4WOy5YCe8NJfnexCaR/1Gn852dhpzPpWeUXN5LqfSqmtzspi9UX4qVX2uW/T7Pa9Z+2U2mjRmb6cPwShrXcqlFRx2/Q7fsz73Pdm33fS8YN82DBozjNqf4aUxw/6jZHmGxU6wyo+71mVc9Lxxtp1Vo7yK1uy16Hd/9UbZ6EdjvpLm+Yr6fpNVYtq0J6ZBn5tW66xL79g8aMx5O5Sy0WFRgj4XO33b+NDTY9GaxaxRonf5qBVM1lkp6FxKh56XTq1gehvlqmQzMn20P1OveaZFq5TsbiabZylpLovtXDY9b7GZtbxWJZshy6ox16RRttko6M7t1G7dBo25jVrPLeraT2d1sb7Oq+7MVe9tPvSLFTuh2NwtdkK2uVueulaiTswSbKf9I5RVe/CyE4L1YCnWkVbB0mvNivVnGbS65dQou92HfdJc9sto1Jrt1tf7blHsf2XPeqf3pB1Zw0epG3WWDxqlnnoDqmX2rm8lmwVvy+UctGZX0skA8/itVTu9mQepmcdNMI+bYB7c2czjJpgH15p5kJKtNfMgVVu7NBeYB2k06jUXmAfptCj2DjAPrllmMA9SM4+bqufSzIPUzIOUtYIwD1KwE16aC8zjJpgHs+5sZ6cxYR5ci5oLzIO06hrMg2u9UTMPUtXnYB5ca+bBfpmNJo3Z2+kwD1LWusA8uLbrd4B5kCb7tpueF+zbwjxIo/YnzIPUzINkecI8SFZ5mAdp0fNgHqSqUWAepEW/O8yDlI1+NCbMgxT1/SarBMyDNOhzMA92yKV3DOZBauZBykaHRQn6HMyD9NDTYR6krFGid/moFUzWWTAP0qHnwTxIb6NmHiSbkTAPUq95wjxIdjeTzTOYx02L7YR5kGxmwTxINkNgHjfBPG6CeZCC7oR5kAaNCfMgRV2DefCNrK9hHqSq9xbmwRtuJxSbu8VOyDZ3YR6kqBMT5kGyfwSYx02XnRCsB2Ee7DqrIMyDZP35+yt0apTd7gPMg3QZjVqz3foa5kGy/xWYBylpR8I8SM08OMsHjQLzIFlmMA+SzYK35QLzYK2TTga4xq9/NGqucRNc4ya4Bnc217gJrsG15hqkZGvNNUjV1i7NBa5BGo16zQWuQTotir0DXINrlhlcg9Rc46bquTTXIDXXIGWtIFyDFOyEl+YC17gJrsGsO9vZaUy4Btei5gLXIK26BtfgWm/UXINU9Tm4Bteaa7BfZqNJY/Z2OlyDlLUucA2u7fod4Bqkyb7tpucF+7ZwDdKo/QnXIDXXIFmecA2SVR6uQVr0PLgGqWoUuAZp0e8O1yBlox+NCdcgRX2/ySoB1yAN+hxcgx1y6R2Da5Caa5Cy0WFRgj4H1yA99HS4BilrlOhdPmoFk3UWXIN06HlwDdLbqLkGqdraR/sTrkFatErJ7mayeQbXuGmxnXANks0suAbJZghc4ya4xk1wDVLQnXAN0qAx4RqkqGtwDb6R9TVcg1T13sI1eMPthGJzt9gJ2eYuXIMUdWLCNUj2jwDXuOmyE4L1IFyDXWcVhGuQrD/hGqRTo+x2H+AapMto1Jrt1tdwDZL9r8A1SEk7Eq5Baq7BWT5oFLgGyTKDa5BsFrwtF7gGa504Gf79Bw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [From = _t, To = _t]),
 #"Add Column" = Table.AddColumn(Source, "Rate", each GetExchangeRate([From],[To]))

in
#"Add Column"

 

 

Which gives me a table like this:

kris10me_1-1693337812405.png

When i click on [Record], it gives me this output

kris10me_2-1693337854383.png

 

The issue with this is that i need every currency type converted to USD, EUR, and SEK.  This last screenshot is the entire output it is giving me (not even close to complete).  

 

I just need a table with 3 columns.  To, From, Rate

ex......   USD, EUR, 1.25

 

1 REPLY 1
ToddChitt
Super User
Super User

Don't click the Record in a row, click the double headed arrow at the top of the Rate column. That will allow you to expand and pick which column you want to add. I bet Rate is one of those available.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors