Range (inclusive) Operator issue in Report builder

Hi Anonymous ,

According to the information you provided, for this type of error it is caused by a wrong setting of the field's type. The values to be compared need to have the same data type.

You use Format function to change the data type or just the date type on the desktop menu.

For example:

Column = FORMAT('Table'[Date],"yyyy-mmmm")

related document link:

Power BI Date Formatting | How to Change Date Format in Power BI? (wallstreetmojo.com)

Using the Field list in Power BI Desktop - Power BI | Microsoft Docs

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.