Forum Discussion

Rodrivieiras's avatar
Rodrivieiras
Icon for Helper I rankHelper I
4 years ago
Solved

Average formula

Hello, I'm starting Power BI studies and I have a table called ProductSales with millions of data to analyze. Below is a sample of the data PERIOD   PRODUCT   PRICE 2001-07   TOY   10 2...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Rodrivieiras 
    Again my mistake

    AverageSold =
DIVIDE (
    COUNTROWS ( 'ProductSales' ),
    COUNTROWS ( VALUES ( Calendar[Month] ) )
)