Forum Discussion

WEW2's avatar
WEW2
Regular Visitor
10 years ago

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...
Tutorial Requests
aksh's avatar
aksh
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Hi

 

I created the below new measure

 

PreviousYearAmount = CALCULATE(SUM[TaxAmt], DATEADD([Invoice Date],-1,YEAR))

 

And I get the below error

Calculation error in measure: A Date column with duplicate dates specified in the call function 'DATEADD'. This is not supported.

 

How do I resolve this?

Many invoices can be generated on a single date.

 

So in the filters provided, if year=2015 and month= Dec , my visual should comparison of Dec-15 amount with Dec-14.

if year=2014 and month= Dec then visual should comparison of Dec-13 and Dec-14.

 

 

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
10 years ago

The 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's avatar
    aksh
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    Hi

     

    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?