Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 year and last year but how do i create a measure that will always display 2016 data for my line?
Any help appreciated.
Solved! Go to Solution.
Sales_2016 = CALCULATE(sales,FILTER(Table;Table[date].[Year]=2016))
Sales_2016 = CALCULATE(sales,FILTER(Table;Table[date].[Year]=2016))
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |