Forum Discussion
Report builder date range parameter
I am trying to create a paramater date range in Report builder and i keep getting this error (Query (1, 90) DAX comparison operations do not support comparing values of type Date with values of type ...
Hi,
Kind of late but this worked for me:
=Format(Parameters!YourParameter.value,"yyyy-MM-dd")
I had this problem when tyring to use a field from a DB2 database that was only date and not datetime and again recently when using a Power BI dataset connection as my datasource. What you want to do is use the above formula in the "Parameter Value" field of your desired dataset. Just replace "YourParameter" with the parameter you want to use. I attached a visual below. Hopefully this helps you out. gpiauilino Hopefully this helps you out too.