Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello guys,
I'm trying to build a PowerBI report that is extracting data from D365. I have a column that is returning a numerical value based on the ID number but in D365 that is a text field. I would like to add a columun that will populate the text name based on the ID number that in the related column. What is the best way to do this?
Thank you.
Solved! Go to Solution.
Hi @mgibson44,
You can try to use lookupvalue to create new calculate column based known id if they not contains multiple matches results. Otherwise you need use calculate and concatenate function to combine correspond result.
Sample formula for calculate column:
formula = LOOKUPVALUE ( Table[ColumnName], Table[ID], [ID] ) formula2 = CALCULATE ( CONCATENATEX ( VALUES ( 'Table'[ColumnName] ), [ColumnName], "," ), 'filter conditons' )
Regards,
Xiaoxin Sheng
Hello guys,
I'm trying to build a PowerBI report that is extracting data from D365. I have a column that is returning a numerical value based on the ID number but in D365 that is a text field. I would like to add a columun that will populate the text name based on the ID number that in the related column. What is the best way to do this?
Thank you.
Hi @mgibson44,
You can try to use lookupvalue to create new calculate column based known id if they not contains multiple matches results. Otherwise you need use calculate and concatenate function to combine correspond result.
Sample formula for calculate column:
formula = LOOKUPVALUE ( Table[ColumnName], Table[ID], [ID] ) formula2 = CALCULATE ( CONCATENATEX ( VALUES ( 'Table'[ColumnName] ), [ColumnName], "," ), 'filter conditons' )
Regards,
Xiaoxin Sheng
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |