Forum Discussion
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,...
johnt75
Super User
Super UserMake 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
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)))