CODEWITHSUNDEEP
powerbipowerquery
Apmartin
Apmartin

Reputation: 85

How do I convert a column full of "Records" to just one column full of one value?

Hey I am working on a project that contains a column that contains only records. Each record has a row labeled "Amount" and row labeled "Currency". The row "Amount" has the value I need and "Currency" is just has the value Null. How do I convert this column of records with just the value for "Amount"? Below is what I am talking about.

Below is a picture of the column filled with records

enter image description here

enter image description here

Above is a picture of opening up the first record when you click on it

I just need that value for "Amount" not for "Currency". What would be the best way to convert this column?

Upvotes: 0

Views: 45

Answers (2)

user3614428
user3614428

Reputation: 36

You can follow the steps below:

  1. Click on the icon just besides the 'Amount' column as shown by blue arrow in the screenshot below. enter image description here

  2. Then, you will get a dialogue box as shown in the screenshot below listing your fields amount and currency. enter image description here

  1. As you want only amount, uncheck the box for currency and hit OK. This should get you the result you want.

Upvotes: 1

horseyride
horseyride

Reputation: 21318

How about adding a custom column with formula

 =Record.Field([Amount],"amount")

Upvotes: 1

Related Questions