Forum Discussion
Date issue
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,
5 Replies
I don't know how, but I solved it 😅
Perhaps post your solution if someone else have a similar question?
Please check the datatype of both the fields in the Power Query.
It has to be the same.
Something is wrong, they won't even go in the same table... Had to create two separate to get them to show.
