Forum Discussion
Date slicer
Hi, I have created a month slicer for my data and it works just fine when viewing a single month of data. However, when I select multiple months or select the 'select all' option, the values ret...
Anonymous , Try like given examples. The second one should work
Average(Table[Value])
Or
AverageX(values(Table[Month Year]),sum(Table[Value]))
amitchandak
Super User
Super UserAnonymous , Try like given examples. The second one should work
Average(Table[Value])
Or
AverageX(values(Table[Month Year]),sum(Table[Value]))
Thanks! the first solution worked. Seems like it was an easy fix.