Forum Discussion
Creating a column using two separate columns from different query.
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.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.
Hi Anonymous
try a LOOKUPVALUE() function, like
Status =
var _initialStatus = LOOKUPVALUE('Table1'[initial test], [ID #], [ID #])
var _finalStatus = LOOKUPVALUE('Table2'[final test], [ID #], [ID #])
RETURN
SWITCH(true(),
NOT(ISBLANK(_finalStatus)), "Ready",
NOT(ISBLANK(_initialStatus )) && ISBLANK(_finalStatus), "In-process",
BLANK()
)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.
Anonymous
have you got any duplicated [ID #] value in your tables?
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
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.
No none of the ID are Duplicated
Inital ID intial test Fianl ID Final test 123
P 123 P 124
P 124 P 125 P New ID status 123
ready 124 ready 125 inprocess Here is my end goal.
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.