Add Column based on filter and field value

[mlewan_ca]

Hello,

I need to add a new column. The value in that column needs to be filtered from ValueID and Value.
Basically I the new column named 162 should look for ValueID 162 and copy value 1.00 to the new column.
Value 180 will add Value 8,500. etc.

Can this be done?

Thanks in advance.

Regards.
mlewan_ca

 

[macfuller]

The .png file is not showing in my browser (Chrome). Can you repost or use the Mr. Excel add-in to show your intention?

 

[mlewan_ca]

Here you go.
It does show up on my preview.

 

[macfuller]

I don't understand. The Value column already has your value, why would you want another column with that same value. Is ValueID unique for the entire column? Or are you saying that you want to create multiple new columns, each named for the respective Value ID?

 

[mlewan_ca]

I don't understand. The Value column already has your value, why would you want another column with that same value. Is ValueID unique for the entire column? Or are you saying that you want to create multiple new columns, each named for the respective Value ID?

I would like to create multiple new columns, each named for the respective Value ID!

 

[macfuller]

I suggest doing that in PowerQuery using the unpivot feature. Much faster - but how many columns will there be? And would the Value populate every row of the new column?

 

[mlewan_ca]

I suggest doing that in PowerQuery using the unpivot feature. Much faster - but how many columns will there be? And would the Value populate every row of the new columnIt would be in

The value would populate in every column off the same ID number. At the end I would like to get one row for each different ID with all values in one row instead of multiple rows.
I have never used the unpivot feature. Do you have an example?

 

[sandy666]

Unpivot columns (Power Query) - Microsoft Support

In Power Query, you can transform selected columns into attribute-value pairs where columns become rows. You use Power Query's Query Editor to unpivot columns.

support.microsoft.com

 

[mlewan_ca]

Unpivot columns (Power Query) - Microsoft Support

In Power Query, you can transform selected columns into attribute-value pairs where columns become rows. You use Power Query's Query Editor to unpivot columns.

support.microsoft.com

I have done this in Excel.
The table is imported from an SQL database not from excel.
Any option to do this in PowerBI?

 

[sandy666]

Exactly the same. Power Query is Power Query