Forum Discussion

junyuchew's avatar
junyuchew
Frequent Visitor
7 years ago

How to populate values from a table with specified dates to another table with all dates

Hi,   I have a table with ProductID and DateID, along with True/False column at specified dates that i would like to populate to another table. Note: There are more than 1000 unique products in the...
Need Help
ryan_mayu's avatar
ryan_mayu
Super User
7 years ago

Hi,

 

I suggest you to create a unique column in both table which is ID&date. Then you can go to Edit Quires-> Merge Queries to import the column from the second table to first if the values in unique column are matching.

  • junyuchew's avatar
    junyuchew
    Frequent Visitor
    7 years ago

    Hi Ryan,

     

    Pardon my phrasing, but I think you misunderstood me. The "desired column" in the second table does not exist. I would like to create a formula to get the "desired column". My second table only has ProductID and DateID but i want to obtain True/False to each row of dates based on information on the first table.

     

    I did some research, but it seems that you can do this using the Complete function in R. Not sure how it can be done in DAX

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      7 years ago

      I think the same way which is to create a unique column and import the value from table A to tabel B (or table B to table A) which has the same values of unique columns.