Forum Discussion

Anmolgan's avatar
Anmolgan
Icon for Post Prodigy rankPost Prodigy
6 years ago

Create Date Column using 2 different tables containg date field

Hi can anyone tell me how can I create a single date column using 2 different date field present in 2 different tables, actually one of the table is not in proper date format, I had build the many to...
Show and Tell
dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi Anmolgan ,

 

I am not clear about your requirement, if possible could you please explain your detailed requirement to me?(such as your expected output ). Then I will help you more correctly. 

And you said that the data won't change, I think this is cuased by there is no direct relationship between Na level in two tables.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anmolgan's avatar
Anmolgan
Icon for Post Prodigy rankPost Prodigy
6 years ago

dax  I just need to have a date table derived from 2 date columns that we have in the two tables, I even create realtionships using customerNA key field but it seems like the matrix which I have build and where it contains customers added, that field is not changing as its suppose to whenever I use the date slicer to see which customers added at which period of time.