Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX Date Parameter Paginated Report Format Error

Hi, I've created a Startdate and EndDate paramater for my paginated report that I'm referencing in my query. Both Startdate and EndDate have been set up as below using DateTime, both available and ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

v-henryk-mstf 

 

Hi Henry,

 

Thanks for the response. I've set my date field to be a dd/mm/yyyy format in my data set and in PBI RB I've tried to write in the paramter to be this same format. I've also included the error message below. This must be a simple fix?

 

 

 

 

Query (4, 2) 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.
----------------------------
Query execution failed for dataset 'Factfile2'.
----------------------------
An error has occurred during report processing.
----------------------------
An error occurred during local report processing.