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")

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I am just trying to filter the entire report by date. If use it all as text and enter date manually then it works. If I configure as a date/time to use the calendar picker in the parameter field then it all fails and I get the error regarding not the expected data type. I am unsure how to configure the data field to be read as a date. Hope this helps clear up my issue.

Thanks Jamie