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] ) )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Rodrivieiras 
Again my mistake

AverageSold =
DIVIDE (
    COUNTROWS ( 'ProductSales' ),
    COUNTROWS ( VALUES ( Calendar[Month] ) )
)
Rodrivieiras's avatar
Rodrivieiras
Icon for Helper I rankHelper I
4 years ago

Hi tamerj1 ,

 

I just changed your formula a little bit by:

 

AverageSold =
DIVIDE (
              COUNTROWS( ProductSales ),
             COUNTROWS ( VALUES(ProductSales[PERIOD] ) 
))
 
It worked perfectly!
 
Thanks a lot!