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

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.