I am just learning, but want to create year over calculations.
Data looks just like this
Model Year Value
black 2017 5
blue 2016 8
My desired end state is this:
Model 2016 2017 Variance Varaince %
Black 500 200 -300 -60&
I can make matrix and charts, but I want to want to create a measures that will allow me to calcuate the variance and varinace percent.
I can do a sum, and create a measure for total year sales, but I cant seem to figure out to make it so it ONLY sums if the year is 2016 or 2017. In excel, i would use a sumif, but I cant see to find it here. How do I essentially make a sumif cheat or is that the wrong way to go?
That is not helpful at all. Can anyone please show me how to write a dax forumal that sums up a column, but only if another column contains a certain data point. For example in excel, it is a simple =SUMIF(B:B,"2017",D:D). Give me the sum of column D, but only if Column b contains the data for 2017.