Adding a custom or "non linked" text column to pivot table

[Keegan4123]

I have a workbook that takes 9 different tables and combines them using power query. This is working fantastic and is giving us a lot of useful data in terms of calculations, and pivot tables. Have had a request though to add a column that includes descriptors that is only going to be created once. Every other data set builds dynamically by month as things are added. I have tried to match names in the new table and brought it into power query, but its not working as planned and hoped someone else has an idea.

It's hard to explain but I did include an example mini sheet.

TLDR: want to add a custom column to pivot table with text or one that is matched to only 1 item

Book1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1
2	Table 1
3	Unit Number	Year	Date	KM					Pivot Table-How I want it								Power Query Table
4	Unit 1	2020	01-Oct-22	5000													Unit Number	Year	Date	KM	HRs	Type
5	Unit 2	2020	01-Oct-22	10000						Oct-22		Sep-22					Unit 1	2020	01-Oct-22	5000
6	Unit 3	2022	01-Oct-22	15000						KM	HR	KM	HR				Unit 2	2020	01-Oct-22	10000
7	Unit 1	2020	01-Sep-22	3000			2020	Unit 1	Pickup Truck	5000	400	3000	300				Unit 3	2022	01-Oct-22	15000
8	Unit 2	2020	01-Sep-22	8000				Unit 2	Small Car	10000	500	8000	400				Unit 1	2020	01-Sep-22	3000
9	Unit 3	2022	01-Sep-22	12000			2022	Unit 3	Big Van	15000	800	12000	700				Unit 2	2020	01-Sep-22	8000
10																	Unit 3	2022	01-Sep-22	12000
11	Table 2																Unit 1	2020	01-Oct-22		400
12	Unit Number	Year	Date	Hrs													Unit 2	2020	01-Oct-22		500
13	Unit 1	2020	01-Oct-22	400					Pivot Table- What I get 1								Unit 3	2022	01-Oct-22		800
14	Unit 2	2020	01-Oct-22	500						Oct-22		Sep-22					Unit 1	2020	01-Sep-22		300
15	Unit 3	2022	01-Oct-22	800						KM	HR	KM	HR				Unit 2	2020	01-Sep-22		400
16	Unit 1	2020	01-Sep-22	300			2020	Unit 1	(Blank)	5000	400	3000	300				Unit 3	2022	01-Sep-22		700
17	Unit 2	2020	01-Sep-22	400				Unit 2	(Blank)	10000	500	8000	400				Unit 1					Pickup Truck
18	Unit 3	2022	01-Sep-22	700			2022	Unit 3	(Blank)	15000	800	12000	700				Unit 2					Small Car
19																	Unit 3					Big Van
20	Table 3
21	Unit Number	Type							Pivot Table- What I get 2, if I remove the year
22	Unit 1	Pickup Truck								Oct-22		Sep-22
23	Unit 2	Small Car								KM	HR	KM	HR
24	Unit 3	Big Van						Unit 1	(Blank)	5000	400	3000	300
25									Pickup Truck
26								Unit 2	(Blank)	10000	500	8000	400
27									Small Car
28								Unit 3	(Blank)	15000	800	12000	700
29									Big Van
30
Sheet1

 

[Keegan4123]

Bumping