Forum Discussion
Months
Hello, i have created a viz that displays the months in chronological order for Planned vs Actual (see first screenshot), however i want to show a month by month comparison despite the year. For exam...
ameera_williams , Create this year vs last year's measure.
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))
or
This year Month = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year]) && 'Date'[Month] = Max('Date'[Month]) ))
Last year Month = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year])-1 && 'Date'[Month] = Max('Date'[Month])))
Thanks Amit. I have created the measure, what do i do with it now?
