Forum Discussion

Anmolgan's avatar
Anmolgan
Post 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 many relationship, whenever I use calender/month filter or calendar key column, my customers filed in the matrix visual do not change, hence I think its not working with the 2 date fields, can anyone suggest me better way to do this?


https://ifitech-my.sharepoint.com/:u:/g/personal/anmol_ganju_ifi_tech/EQj-srAlY8ZJvxRPNWwVmcEBQim8bh0zGyPKOFZO3Cr3-g?e=FO44bi

 

Show and Tell

2 Replies

  • dax's avatar
    dax
    Community 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
      Post 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.