Forum Discussion
How to get average CB PVs by PMonth?
Hello, I have the following tables I want to get the average CB PVs per meta ID by PMonth ... it works with the calendar hierarchy and doesn’t with both PMonth and PDate ... why? How to get it ...
amitchandak
Super User
Super UserSA2 , do need sum of PV and then avg like ?
Avergaex(values('Date'[Month Year]), calculate(Sum(CV[PV]) ) )
amitchandak
Trying this formula is fine with calendar hierarchy as before, however it is still not working with PMonth