How to display data in clustered column chart - when working with date data
I'm a bit stuck, with something that feels should be quite simple - so I hope somebody can help me with this.
Basically I've got a table with sales data statistics:
ProductId, SalesDate and GrossSalesValue
This table holds data for a few years and I need to present side by side performance this year vs last year.
In Excel creating such a chart is very simple (see screenshot at the end of this post). I see that it takes two columns - one for 2016. year and second for 2017. year. But my table holds one field for GrossSalesValue and other for dates. Can I get from such a table clustered column chart to compare year data side by side? Can I achieve this with measures and DAX? I've tried TOTALYTD and Calculate(...; SamePeriodLastYear), but it didn't work