Forum Discussion
junyuchew
7 years agoFrequent Visitor
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...
junyuchew
7 years agoFrequent Visitor
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
7 years agoSuper User
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.