Forum Discussion
Add Two Column
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
9 Replies
- TomMartensSuper User
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
- BenjoshHelper I
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.
- Ashish_MathurSuper User
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.
- BenjoshHelper I
No, pl refer to my reply
- Ashish_MathurSuper User
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.
- BenjoshHelper I
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 solutionHope I wrote in a polite way
Thanks,JOSh