cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mgibson44 Frequent Visitor
Frequent Visitor

PowerBI D365 Report. I need a populate a text column based on a number column

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: PowerBI D365 Report. I need a populate a text column based on a number column

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
2 REPLIES 2
Highlighted
mgibson44 Frequent Visitor
Frequent Visitor

D365 to PowerBI Need to turn a formula for a number column to text

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. 

Community Support Team
Community Support Team

Re: PowerBI D365 Report. I need a populate a text column based on a number column

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |