Forum Discussion

procyon82's avatar
procyon82
Icon for Resolver I rankResolver I
10 years ago
Solved

Averages

Hi,   What is the best way to create calculated monthly data in Power BI desktop?   I have a set of daily data and if I let's say want to display the data monthly, it works great until you do a c...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    Right, sorry, you have to use aggregates in a measure, so the proper formula would be:

     

    Pages/Session = DIVIDE(SUM([Pageviews]),SUM([Sessions]),0)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Right, sorry, you have to use aggregates in a measure, so the proper formula would be:

 

Pages/Session = DIVIDE(SUM([Pageviews]),SUM([Sessions]),0)
procyon82's avatar
procyon82
Icon for Resolver I rankResolver I
10 years ago

Greg_Deckler That did it! Thanks a lot.