Forum Discussion
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 ...
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.
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()
)