Forum Discussion
acanepa
Resolver I
Resolver IDivide as Pivot Table
Hello, I'm having problems with the division in PowerBI. The report is for repurchase rate. I have a database with a list of clients, where I have month of purchase, money spent and more. The mos...
You should not need any column other than RR_2 and your date column. Create a measure with the following formula:
Measure = DIVIDE(SUM([RR_2]),COUNT([RR_2]))
Note that:
Measure = SUM(RR_2)/COUNT(RR_2])
will also work if you are not worried about divide by zero issues, which you probably don't need to worry about since you shouldn't have zero rows.
Greg_Deckler
Community Champion
Community ChampionYou should not need any column other than RR_2 and your date column. Create a measure with the following formula:
Measure = DIVIDE(SUM([RR_2]),COUNT([RR_2]))
Note that:
Measure = SUM(RR_2)/COUNT(RR_2])
will also work if you are not worried about divide by zero issues, which you probably don't need to worry about since you shouldn't have zero rows.