Forum Discussion

Anonymous

Not applicable

7 years ago

Creating Slicer

I have data that looks like this: What I'm aiming to do is create a slicer that is based on the average of the estimated annual revenue column, grouped by year. I've found this tricky to...

Solution Supplier

7 years ago

Hi Anonymous ,

Please see the following column formula;

Average =

var year = year(Table1[CloseDate])

return

CALCULATE(SUM(Table1[Estimated Annual Revenue]),year(Table1[CloseDate])=year)/CALCULATE(COUNT(Table1[Estimated Annual Revenue]),year(Table1[CloseDate])=year)

Please let me know if this meets your requirements :)

Thanks,

George

Forum Discussion

Creating Slicer

Related content

Creating date slicer removes data

Creating a dynamic slicer

Can i use a measure selected in a slicer (created with field parameters) to create a rank?

Create Slicer

Creating relationships