Forum Discussion
Column Type Mismatch Between Desktop and Query Editor
Do you have a date table in the model (and is there a relationship to 'Response Delivered')?
Hi, Anonymous
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may use Date.FromText to convert the data type from text to date and give the column a 'Date' data type. You can add a new step as below.
Table.TransformColumns(#"Changed Type",{"Date",each Date.FromText(_),type date})
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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!