Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Aggregation based on Average

I have the following table:   ID            Transaction Date 1              1/31/2018 2               1/31/2018 3               1/31/2018 4                2/28/2018 5                2/28/2018 ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

You could create a measure:

Average = COUNT('Table'[ID])/12

 

Add 'Transaction Date' hierarchy (remove all levels except for 'Year') and above measure into table visual.

 

Regards,

Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I would need that as a seperate measure to show on my visuals. I should not be showing the transaction date as part of my visuals.