Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Creating a new range column in Power Query

Hi,   I'm currently working with some survey data in Power BI and struggling to creating a new range column based on two other columns. The collection of age data has changed at some point thr...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

     

    Your Age Dimension table has all the unique entries, right? Here is one way, added one row to show the result

     

     

     

    (x)=> if x[nyaldrp]>0 then x[alder]
else dimAge[Age_BK]{ List.PositionOf(dimAge[Custom],List.Select(dimAge[Custom], each List.Contains(_,x[alder])){0})}?

     

    Added one Custom column in dimAge 

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

 

Your Age Dimension table has all the unique entries, right? Here is one way, added one row to show the result

 

 

 

(x)=> if x[nyaldrp]>0 then x[alder]
else dimAge[Age_BK]{ List.PositionOf(dimAge[Custom],List.Select(dimAge[Custom], each List.Contains(_,x[alder])){0})}?

 

Added one Custom column in dimAge