Calendar table error "multiple values"

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

it should show all cases depend on the date a user choose but those 5 years and more must be applied in every chosen day in a calendar

[Anonymous]

from 01/01/1961 - 08/10/2019 

[HotChilli]

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

[Anonymous]

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.

[Anonymous]

with the current date, 5 years a more older, I can upload power bi file pbix

[Kedar_Pande]

What is the range of expected dates?