Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
My existing PBI import the CRM module :-
Now i need to add one more field name "Product"
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
Solved! Go to Solution.
@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"
@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"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |