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
Anonymous
Not applicable

Creating a custom column with field value populate from another table using M query

Hi all,

 

I am trying to create a custom column in one of the table below (IE36_Append_main) and this custom column is going to populate the value based on another field in another table (i.e. License Plate Relevancy [License Plate Relevant]). Both of the two tables can be linked using Vehicle Type as the key. (see following data model).

 

I am coding the followng style but it doesn't work:

if License Plate Relevancy.[Vehicle Type] = [Veh. Type]

   then License Plate Relevancy.[Licence plate relevant]

else 0

Please help. Thanks. Tuff

F1.JPG

1 ACCEPTED SOLUTION

Hi,

You can simple join the Tables.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

In the IE36_Append_main table, write this calculated column formula

=RELATED(License Plate Relevancy[Vehicle Type])

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Hi Aishid

 

I am trying to get the value in the Power Query M and not using Dax.

Do you know how to resolve my issue via Power Query M? please let me know. thanks.

 

Regards,

Yong

Hi,

You can simple join the Tables.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.