Forum Discussion
Help with Clustered Column Chart
Thanks Sean for your help on this.
I had changed the formular. However, I seam to have two identical lines. In other words, the fomular does not seem to alter my result. Would you please take anther look at the screen below.
here is my fomular: Set Date 2015 = CALCULATE(COUNTA('Meters Sold vs Set'[Set Date]), 'DateKey'[Year] = 2015)
Thanks Sean
AndrewDang You have 2 options (each has its advantages)
OPTION 1
Create another Measure using the same formula just change 2015 to 2016
Set Date 2016 = ...... just change 2016 at the end
OPTON 2
You can also create (CY- Current Year and PY - Previous Year) - WATCH the results if you have Year Slicer though !!!
Set Date PY = CALCULATE(COUNTA('Meters Sold vs Set'[Set Date]), FILTER('DateKey', 'DateKey'[Year] = MAX('DateKey'[Year])-1))
Set Date CY = CALCULATE(COUNTA('Meters Sold vs Set'[Set Date]), FILTER('DateKey', 'DateKey'[Year] = MAX('DateKey'[Year])))
Let me know if this works!
I have tried both options but my line does not seem to change at all. i am not sure if my Date Dimension table is off? I have followed this tutorial to create my date table:
http://community.powerbi.com/t5/Desktop/How-do-i-create-a-date-table/m-p/23896/highlight/true#M7605
No manater what year I changed to, it does not seem to change the result at all.
Do you get the correct result form the Measures I gave you if you put in just a Table?
And post a screenshot so I can see what you have in the Vizualizations and Fields area?
Here is the screenshot with Visualizations and Fields boxes. I had my Date Dimension goes out to 2017 so my current year = max -1; and previous year = max -2. However, the two fomulars return identical results. I have checked my data set and verified that I have set dates in both 2015 and 2016.
Thanks Sean. I really appreciate your help here.