Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Creating a column using two separate columns from different query.

Hello,   I have been trying to figure out how I can create a column that are based off of he date from 2 seperate columns that come from 2 seperate querys.   Example   Query/table 1             ...
  • Anonymous's avatar
    Anonymous
    6 years ago

    why don't you merge two tables based on id's.

     

    Then create calculated column for status.

     

    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.

  • Anonymous's avatar
    Anonymous
    6 years ago

    az38 Anonymous 

     

    So Feeling really stupid but I was able to just merge the columns and make it work. Sorry it only my 3week uring power bi now and Thank you both for all teh help. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

When i attempted this i got an error code 

"A table of multiple values was supplied where a single value was expected."

 

 

When I creates a column using lookup it only  transfered data for ID that final had and notthat ones that inital bad but final didnt.

 

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

have you got any duplicated [ID #] value in your tables?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    why don't you merge two tables based on id's.

     

    Then create calculated column for status.

     

    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Anonymous 

       

      So I tried merging them and had the same issue. where the data that is in the inital only transfer over test data for that of the final id and none that the final id didnt have. 

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    az38 

    No none of the ID are Duplicated 

     

     

    Inital ID intial test Fianl ID Final test 

    123

    		P123P

    124

    		P124P
    125P  

     

    New IDstatus 

    123

    		ready
    124ready
    125inprocess 

     

    Here is my end goal. 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous 

      Create new column 

      Status=If(table[inittial test]="Pass" && table[final test]="Pass","Pass","Inprogress")

       

      Thanks & regards,
      Pravin Wattamwar
      www.linkedin.com/in/pravin-p-wattamwar

      If I resolve your problem Mark it as a solution and give kudos.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Anonymous  yes this status code would work but since all the test data is not being transfered over to the merged column either 

         

        i woudl only getht he test data for only id that the final table woudl have and none for any additional id intal testing would have. 

         

        I have tried using the userelationship and it also did the same. 

         

        Inital test = CALCULATETABLE(SUMMARIZE('Inital','Inital'[Pass/ Fail ]),USERELATIONSHIP('inital '[ID ],'C of C'[ID]) )
        and this also did not transfer all the data.