Forum Discussion
Calendar table error "multiple values"
Hello
I am having problem with the calendar "A table of multiple values was supplied where a single value was expected.".
Calendar = CALENDAR(DATEADD(SaleDetail[Saledate], -5, YEAR), TODAY())
Can someone help mewith this error? Please don't put a link as I am beginner need to see an example or correct solution. Thank you for understanding.
Poco
7 Replies
Hi Anonymous
If you want to get data from the past five years up to now, you can use the between slicer. If not, please provide sample data that fully covers your issue and the expected outcome based on the sample data you provided.Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What is the range of expected dates?
DATEADD returns a table but you want a single date as the first parameter. Test it by hardcoding a date in there, for example,
DATE(2020,10,15)If you get that to work, construct the actual date you are trying to get
