Forum Discussion

aflip's avatar
aflip
Frequent Visitor
3 years ago
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...
Need Help
  • bsheffer's avatar
    bsheffer
    3 years ago

    change your date to 

    date(2023,01,01)
aflip's avatar
aflip
Frequent Visitor
3 years ago

bsheffer Thank you! That did work. Now if I were to change it to be: FILTER('Sheet1',SELECTEDVALUE(Sheet1[Accrual_Period_Date]))

How can I get that to work?