Forum Discussion

marcelmunk's avatar
marcelmunk
Frequent Visitor
4 years ago
Solved

Retrieve value from same row based on column name in column

Hi,   Pretty basic question (I believe) as I'm a beginner in Power BI and still on my basics on DAX.   I have a Table which has the Product Name and many properties   I want to add a new ...
Need Help
  • NickOP's avatar
    NickOP
    4 years ago

    Here's an alternative solution that reads the record itself:

    = Table.AddColumn(Source, "Value", each Record.FieldOrDefault(_,[Desired Property], null))
Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

In this case, use below formula

= try Table.Column(Source,[Desired Property]){List.PositionOf(Table.ColumnNames(Source),[Desired Property])} otherwise null
marcelmunk's avatar
marcelmunk
Frequent Visitor
4 years ago

Vijay_A_Verma , I'm getting null for the 3rd row. Should be a 'Z'. Can't figure out why: