Forum Discussion

Benjosh's avatar
Benjosh
Helper I
5 years ago
Solved

Add Two Column

I'm trying to achieve the below output. 

Property TypeUsage TypeOutput
ResidentialHouseResidential
Non-ResidentialShopnon Residential
 Multi-floors BuildingHouse
  Shop
  Multi-Floors Building

Kindly support

9 Replies

  • 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

  • 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. 

  • 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.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super 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.

  • 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