Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

DateAdd Measure

Hi Guys,

Please I am trying to create new measure this the follwoing:

LY Sales = CALCULATE([TotalSales], DATEADD('Date'[Date],-1,Year))

PowerBI retrurns error on the 'Year'

Kindly help!

v-frfei-msft
7 years ago
Hi Anonymous,

If the issue still occur, kindly share your pbix to me . Please upload your files to One Drive and share the link here.

Regards,

Frank

4 Replies

Stachu
Community Champion
7 years ago
what's the error exactly? What's the syntax for [Total Sales]?
is the Date table marked as Date table, with Date[Date] as key column? see here https://docs.microsoft.com/en-us/power-bi/desktop-date-tables
is the join set to 1:many with single direction?
- Anonymous
  Not applicable
  7 years ago
  Hi Stachu,
  
  Please se the screen shoot above
  Thanks
  - Stachu
    Community Champion
    7 years ago
    weird, syntax looks correct, but maybe you can try with this one:
    LY Sales = CALCULATE ( [TotalSales], DATEADD ( 'Date'[Date], -1, YEAR ) )
    I usually use https://www.daxformatter.com/ to verify syntax, maybe the spaces+capital letters will help
v-frfei-msft
Community Support
7 years ago
Hi Anonymous,

If the issue still occur, kindly share your pbix to me . Please upload your files to One Drive and share the link here.

Regards,

Frank