03-08-2017 12:11 AM
I am wondering what is wrong with my DAX formula or with my graph.
I made a graph with on the axis, date and on values I placed average per year.
The formula I am using to determine my average per year already got a date in it, it uses the date table.
I would like to get some help with figuring out where the problem is
average amount of unique visitors 2016 = CALCULATE(
AVERAGEX('amount of unique visitors','amount of unique visitors'[amount of unique visitors]),
'Datedimension'[Datekey]>= DATE(2016, 1 , 1),
Thanks in advance