Forum Discussion

luanamoreschi's avatar
luanamoreschi
Frequent Visitor
3 years ago

QTD Questions — Time Intelligence - Same Period Last Year

Hello Everyone!

I'm facing some difficulties in calculating the YoY Growth (sharing QTD sales vs the same period last year)


I'm using the formula below to calculate the QTD Orders from this year, and the result is coming right

QTD Sales = CALCULATE(COUNT('Orders'[Order Date]),DATESQTD(('Orders'[Order Date])))


The problem is in the formula that calculates the same period from last year:

Last Year QTD Orders = calculate(count(Orders'[Order Date]),DATESQTD(DATEADD('Orders'[Order Date],-1,YEAR)))

It's bringing a higher result than it is.

I don't know if the problem is in my calendar, which was built this way:

Calendar =
var mindate = year(MIN('Orders'[Order Date]))
var maxdate = YEAR(MAX('Orders'[Order Date]))
return

ADDCOLUMNS(
FILTER(
CALENDARAUTO(),
YEAR([Date]) >= mindate && YEAR([Date]) <= maxdate
),
"Year", YEAR([Date]),
"Month", FORMAT([Date],"mmmm"),
"Month_Number", MONTH([Date]),
"Quarter", FORMAT([Date], "\QQ"
)
)

 

Thanks in advance!!

 

2 Replies

  • Make sure that your calendar table is marked as a date table and then use the 'Calendar'[Date] column in the measures rather than the order date column

    • luanamoreschi's avatar
      luanamoreschi
      Frequent Visitor

      Hi, thanks for your reply.

      I did this and it is now showing the results of the entire quarter in the last year... 

      Last Year QTD Orders  = calculate(count('Orders'[Order Date]),DATESQTD(DATEADD('Calendar'[Date],-1,YEAR)))