Forum Discussion
msommerf
Helper III
Helper IIIBar & Line Chart for fixed Year
Hi, I am looking to create a Bar & Line chart displaying Sales This Year against Sales Last Year as bars with a line displaying sales for a fixed year of 2016. I can easily get sales this yea...
Sales_2016 = CALCULATE(sales,FILTER(Table;Table[date].[Year]=2016))
Assuming your date has a hierarchy, did you try something like that ?Create a new measure similar to the old one and add a filter to it (replace sales with your formula)
Sales_2016 = CALCULATE(sales,FILTER(Table;Table[date].[Year]=2016))
Assuming your date has a hierarchy, did you try something like that ?
Create a new measure similar to the old one and add a filter to it (replace sales with your formula)