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

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.
     
     
    • az38's avatar
      az38
      Community Champion
      6 years ago

      Anonymous 

      try to first create a new calculated table:

       

      dimID = DISTINCT('table1'[ID #])

       

      then create a column in this new table

       

      Status = 
var _initialStatus = CALCULATE(MIN('Table1'[initial test]), 'Table1'[ID #]='dimID'[ID #])
var _finalStatus = CALCULATE(MAX('Table2'[final test]), 'Table2'[ID #]='dimID'[ID #])
RETURN
SWITCH(true(),
NOT(ISBLANK(_finalStatus)), "Ready",
NOT(ISBLANK(_initialStatus )) && ISBLANK(_finalStatus), "In-process",
BLANK()
)

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        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.