Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
admin11
Memorable Member
Memorable Member

it is possible to add new field name to my CRM module ?

Hi All

My existing PBI import the CRM module :-

admin11_0-1619575708772.png

Now i need to add one more field name "Product"

admin11_1-1619575754448.png

May i know it is i just need to change the M Code ?

My PBI file :-

https://www.dropbox.com/s/4tje2j7rx9cn9x5/PBT_V2021_400%20CRM_TS.pbix?dl=0

 

Hope some one ccan advise , what is the correct approach ?

 

Paul Yeo

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@admin11 , I am assuming this there in the database and you want to add it.

Right click on the table in Power Query, Open Advance editor, and add that to the field list

refer to my video -https://www.youtube.com/watch?v=h0yLtceT0i4

 

In case this based on some logic, you have to use if then else 

 

example

if [name] ="ABC" then "AA" else "BB"

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@admin11 , I am assuming this there in the database and you want to add it.

Right click on the table in Power Query, Open Advance editor, and add that to the field list

refer to my video -https://www.youtube.com/watch?v=h0yLtceT0i4

 

In case this based on some logic, you have to use if then else 

 

example

if [name] ="ABC" then "AA" else "BB"

@amitchandak 

Your youtube video very helpful.

Thank

Paul

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.