Forum Discussion
Column Type Mismatch Between Desktop and Query Editor
- 5 years ago
Do you have a date table in the model (and is there a relationship to 'Response Delivered')?
The formula you sent gives me an error (and I did adapt it for my column names when I tried it), but the data is already listed as a date format on the editor. The main screen where I am building the dashbaord still will not show the "response delivered" data as a date though even though I've done this for 2 of the other columns here and they worked perfect like normal.
Any help is greatly appreciated!
Do you have a date table in the model (and is there a relationship to 'Response Delivered')?
- Anonymous5 years agoNot applicable
Yes this fixed the issue, thank you so much HotChilli !!
- Anonymous5 years agoNot applicable
I think that's what's causing the issue! This is part of two appended tables and Bi chose the "response delivered" column as the key