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()...
HotChilli
Community Champion
Community ChampionDATEADD 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
can you be more specific? an example for "If you get that to work, construct the actual date you are trying to get"? Thank you.