How to obtain class description

Question

Hi&nbsp;I am new to Power BI.&nbsp; I like to obtain Class Description in Sales Table from Booking Class using Carrier and Class as relationship.Appreciate advice. Thanks.&nbsp;Sales Table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Inv. No.Inv. DateClassCarrierTotal&nbsp;&nbsp;Air FareTaxesService&nbsp;&nbsp;Hotel &amp;&nbsp;VisaCanx &amp;&nbsp;Total&nbsp;Class&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Ticket&nbsp;&nbsp;&nbsp;Fee&nbsp;Package&nbsp;&nbsp;Others&nbsp;Sales&nbsp;Description&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;123&nbsp;03/01/18Y/ESQ12,563.00250.4060.00&nbsp;&nbsp;&nbsp;2,873.40Econ/Econ124&nbsp;04/01/18QTG1352.00101.8030.00&nbsp;&nbsp;&nbsp;483.80Economy125&nbsp;05/01/18DBA17,477.00997.9060.00&nbsp;&nbsp;&nbsp;8,534.90Business126&nbsp;05/01/18QTG1352.00101.9030.00&nbsp;&nbsp;&nbsp;483.90Economy127&nbsp;23/01/18DNH12,320.0059.2060.00&nbsp;&nbsp;&nbsp;2,439.20Business128&nbsp;23/01/18DNH11,740.0059.2050.00&nbsp;&nbsp;&nbsp;1,849.20Business129&nbsp;23/01/18DNH12,320.0059.2060.00&nbsp;&nbsp;&nbsp;2,439.20Business130&nbsp;24/01/18Y/ESQ11,545.00146.8050.00&nbsp;&nbsp;&nbsp;1,741.80Econ/Econ131&nbsp;24/01/18E/YSQ11,545.00146.8050.00&nbsp;&nbsp;10.001,751.80Econ/Econ132&nbsp;29/01/18ESQ1672.0048.8040.00&nbsp;&nbsp;&nbsp;760.80Economy133&nbsp;07/02/18QTG1332.00102.0030.00&nbsp;&nbsp;&nbsp;464.00Economy134&nbsp;14/02/18H/KKE1525.00347.2040.00&nbsp;&nbsp;&nbsp;912.20Econ/Econ135&nbsp;14/02/18J/ESQ12,819.0066.0080.00&nbsp;&nbsp;&nbsp;2,965.00Biz/Econ136&nbsp;01/03/18E/BSQ1691.0067.9040.00&nbsp;&nbsp;&nbsp;798.90Econ/Biz137&nbsp;09/03/18W/LJL11,395.00172.1050.00&nbsp;&nbsp;&nbsp;1,617.10Prem Econ/EconBooking Class code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CarrierClassRemarks&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;JLLEconomy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;JLWPremium Economy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KEHEconomy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KEKEconomy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NHDBusiness&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SQBEconomy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SQCBusiness&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SQDBusiness&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SQEEconomy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SQJBusiness&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SQNEconomy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SQQEconomy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SQSPremium Economy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SQTEconomy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SQYEconomy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SQZBusiness&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TGQEconomy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

v-qiuyu-msft · Answer

Hi&nbsp;Grace1,
&nbsp;
From your post, the Class Description column should exist in Sales Table. Would you please clarify the words "I like to obtain Class Description in Sales Table from Booking Class"?&nbsp;
&nbsp;
In Power BI desktop, only one active relationship is supported between two tables. You can create a relationship between Carrier columns in these two tables with many to many relationship.&nbsp; For detail information, I would suggest you go through this document:&nbsp;https://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationships
&nbsp;

&nbsp;
&nbsp;
Best Regards,Qiuyun Yu&nbsp;

parry2k · Answer

Grace1 here is the solution, add column in each table
&nbsp;
New column in BookingClass TableCarrierClassKey = BookingClass[Carrier] &amp;&amp; BookingGlass[Class]
New column in Sales Table
CarrierClassKey = Sales[Carrier] &amp;&amp; Sales[Class]

Once you have above columns added, set relation between these two table on this new column. After relationship, you add another new column in sales table to get class description
&nbsp;
Class Description = RELATED( BookingClass[Remarks])

Forum Discussion

How to obtain class description

2 Replies

Related content

Class not registered error

Obtain highest level parent recursively

Accumulated Histogram from Classes obtained by Measures

Asset Description with same class

Obtain Dates from Weeknumber

Sales Table
Inv. No.	Inv. Date	Class	Carrier	Total	Air Fare	Taxes	Service	Hotel &	Visa	Canx &	Total	Class
				Ticket			Fee	Package		Others	Sales	Description

123	03/01/18	Y/E	SQ	1	2,563.00	250.40	60.00				2,873.40	Econ/Econ
124	04/01/18	Q	TG	1	352.00	101.80	30.00				483.80	Economy
125	05/01/18	D	BA	1	7,477.00	997.90	60.00				8,534.90	Business
126	05/01/18	Q	TG	1	352.00	101.90	30.00				483.90	Economy
127	23/01/18	D	NH	1	2,320.00	59.20	60.00				2,439.20	Business
128	23/01/18	D	NH	1	1,740.00	59.20	50.00				1,849.20	Business
129	23/01/18	D	NH	1	2,320.00	59.20	60.00				2,439.20	Business
130	24/01/18	Y/E	SQ	1	1,545.00	146.80	50.00				1,741.80	Econ/Econ
131	24/01/18	E/Y	SQ	1	1,545.00	146.80	50.00			10.00	1,751.80	Econ/Econ
132	29/01/18	E	SQ	1	672.00	48.80	40.00				760.80	Economy
133	07/02/18	Q	TG	1	332.00	102.00	30.00				464.00	Economy
134	14/02/18	H/K	KE	1	525.00	347.20	40.00				912.20	Econ/Econ
135	14/02/18	J/E	SQ	1	2,819.00	66.00	80.00				2,965.00	Biz/Econ
136	01/03/18	E/B	SQ	1	691.00	67.90	40.00				798.90	Econ/Biz
137	09/03/18	W/L	JL	1	1,395.00	172.10	50.00				1,617.10	Prem Econ/Econ
Booking Class code
Carrier	Class	Remarks
JL	L	Economy
JL	W	Premium Economy
KE	H	Economy
KE	K	Economy
NH	D	Business
SQ	B	Economy
SQ	C	Business
SQ	D	Business
SQ	E	Economy
SQ	J	Business
SQ	N	Economy
SQ	Q	Economy
SQ	S	Premium Economy
SQ	T	Economy
SQ	Y	Economy
SQ	Z	Business
TG	Q	Economy