Forum Discussion
DATESBETWEEN Date and Time Field
Im confused. I've read for Date and time functions that's its best to have a date or calendar table. I have a table called reservations with the following fields: DriverID (string), PickUpDate (Da...
MattAllington
Community Champion
Community ChampionThe first parameter of DATEADD should be the column in your Calendar table. It looks like you are using a measure or a column in your fact table
aksh
Microsoft Employee
Microsoft EmployeeHi
Sorry, I didn't get your message.
I want to know if I am creating a new measure (not a new column) can't I use a date column that has multiple duplicate values?
What is the resolution to this problem?
SeanTime Intelligence Functions which DATEDD is one of - require a Date/Calendar table in your Data Model.
Go to Matt's link here and create one
http://www.powerpivotpro.com/2015/02/create-a-custom-calendar-in-power-query/
Then change your formula
PY Amount = CALCULATE(SUM([TaxAmt]), DATEADD(CalendarTableName[DateColumn], -1, YEAR) )