When I use this formula for YTD sales, I don’t get an error:
YTD Invoiced =
FILTER(all(DateTable2),DateTable2[Week Number]<WEEKNUM(today()+1)),Invoices[Total Invoiced])
This worked in 2019 because we only had a half year of 2019 data. I am trying to make this work for 2020 but when i do this I get an error:
I’d appreciate any suggestions to tweak this to recognize 2020 data and only capture that for YTD Sales Invoiced Sales.