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 Text. Consider using the VALUE or FORMAT function to convert one of the values.) the column shows its a date / time when i open the dataset in power BI and even in the database that column shows its date however when i try to use it a parameter date range i get an error . Does anyone have any idea of how to resolve this in report builder?
Kind of late but this worked for me:
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.
I have follwed all vedios and google, and it do not work.... The issues is that the dax is hard to understand. The calender date is a date format, but when passing in query it is asking for a text. Vedio all takes the date as date formate but the query is still asking for a text...
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.