Date issue

[Roodakker]

Hi, 

I am trying to create a visualization of responserate per month in a survey report. In the first step of doing this I have created a relationship between my Survey table and date table, and the same with my Survey Sent table which is a row with a date for every survey that has been sent. I've then done two countrow measures and when putting them in a simple table visualisation sorted on month the date-relationship to SurveySent won't work. Why? 

Greatful for help, 

[Roodakker]

I don't know how, but I solved it 😅

[andhiii079845]

Perhaps post your solution if someone else have a similar question?

[rajulshah]

@andhiii079845 ,

Please check the datatype of both the fields in the Power Query.

It has to be the same.

[rajulshah]

@Roodakker , can you please try to plot all the 3 columns in a table visual and then paste the screenshot here?

[Roodakker]

Something is wrong, they won't even go in the same table... Had to create two separate to get them to show.