Add Two Column

[Benjosh]

I'm trying to achieve the below output. 

Property Type	Usage Type	Output
Residential	House	Residential
Non-Residential	Shop	non Residential
	Multi-floors Building	House
		Shop
		Multi-Floors Building

Kindly support

[Benjosh]

Hi,
Apologize for any inconvenience cause 
but actually, I can't be creating tables & appending because my data is live from API & table is formed 
I looking for DAX measure or calculated columns or Advance editor for my solution 

Hope I wrote in a polite way 

Thanks,

JOSh

[Ashish_Mathur]

Assuming Property Type and Usage type are 2 seperate tables (with one column in each table), rename the column in any one table to match the heading of the other table.  In the Query Editor, append the 2 tables.

Hope this helps.

[Benjosh]

No, pl refer to my reply 

[Ashish_Mathur]

Hi,

Split the single table of 2 columns into 2 tables of one column each.  Follow my instructions in the previous message.

Hope this helps.

[Benjosh]

No, It won't work. I have tried all possible ways & writing in the community for support.

pl reply with examples or snapshots with excepted output

[Ashish_Mathur · Accepted solution]

Hi,

Download my PBI file from here.

Hope this helps.

[Benjosh]

My Question was wrong, I accept the given solution.

[Benjosh]

My Input is from API & added to a single table & the values of SubGroup_Name & USG_Name should be added to one column output

Output

Residential

Residential

Others

Others

Residential

Other

 Note: I'm new to Power BI, Also new to development. 

[TomMartens]

Hey @Benjosh,

w/o know how the input looks like it's difficult (not to say impossible, at least for me) to provide guidance on how to create the output.

Regards,

Tom