Forum Discussion
Year over Year with tricky dates
Hi, I have data with fiscal quarter (text field) as the lowest aggregation level on each transaction. I have a calendar table that includes a related Start Date and End Date for each fiscal quarter, ...
lmondavi try something like this. Just try writing the formula instead of copy pasting as I might have missed out quotes.
CALCULATE(SUM(DataTable[Revenue]), FILTER(CalendarTable, CalendarTable[Start Date] >= DATEADD(CalendarTable[Start Date],-1,Year) && CalendarTable[End Date] < DATEADD(CalendarTable[End Date],-1,Year)))
Unfortunately that didn't work, thanks for the reply though