Forum Discussion

jsteffe's avatar
jsteffe
Icon for Helper III rankHelper III
5 years ago
Solved

Problem with previousYear function

I gest these 2 measures : total_of_sales = SUM(Order_details[total_without_discount]) Total_sales_previous_year = CALCULATE([total_of_sales],PREVIOUSYEAR('Calendar'[Date]))   I don't understan...
Need Help
  • linh091's avatar
    linh091
    5 years ago

    Can you share your file with shorten data? I want to see what's your date format.

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

Try:

Total_sales_previous_year = CALCULATE([total_of_sales], DATEADD('Calendar'[Date], -1, YEAR))