Forum Discussion
Solved
FILTER function resulting in error - HELP
I have a dataset consisting of lease numbers, accrual periods, production dates, and volumes by product. I'm trying to do a simple FILTER() function as a measure, but am getting this error: "The expr...
change your date to
date(2023,01,01)
I don't think you can as the slicer is filtering the table to the accrual date. You can't show the prior period on that filtered table.
I created a new forum message detailing exactly what I want to do here. Thanks so much for your help! Take a look at this if you have time:
https://community.powerbi.com/t5/Desktop/Need-to-create-measure-that-compares-between-the-selected-date/m-p/3108148#M1053430