Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 ...
Need Help
  • nr_q's avatar
    nr_q
    Frequent Visitor
    7 months ago

    This is it, this is the answer. Was struggling with this off a semantic model hosted on Fabric, he shows the correct DAX to use instead of jumping through the string formatter hoops. I ended up needing to use SELECTCOLUMNS() in addition to SUMMARIZECOLUMNS() to get similar results to my Dashboard results, but this pointed me in the right direction. Thank you Heba!