Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help needed with Report Builder

I am trying to put in a date parameter and having issues. Please Help.           Query (1, 104) DAX comparison operations do not support comparing values of type Date with values of type ...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    I was able to format my date using expressions and now that report functions as it should

    Thank you for the input

    Jamie

  • Anonymous's avatar
    Anonymous
    5 years ago

    =Format((Parameters!FromFinalTablePostedPostingDate.Value), "MM-dd-yyyy")

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Anonymous 

 

Glad that you have found the solution. Can you share your formatting expressions and the data types of both paramter and column field? 

 

My date column in SQL DB is Text type. However, when I connect to it in Report Builder, I can set a parameter with date/time type to filter the report. And I cannot reproduce "The property doesn't have the expected type" error. Not sure if there is some type detection or convertion happening automatically. 😅

 

Regards,
Jing

Anonymous's avatar
Anonymous
Not applicable
5 years ago

=Format((Parameters!FromFinalTablePostedPostingDate.Value), "MM-dd-yyyy")

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    Thank you