Forum Discussion

Resolver 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...

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)

Microsoft Employee

10 years ago

I assume you have a set of daily data as below. You can create a new column to identify the month and year for each date with following formula.

Month Year = FORMAT ( 'GA Traffic'[Date], "mmmm, yyyy" )

Then you can create a measure which mentioned by Greg_Deckler and drag a Table chart into your canvas as below.

Pages/Session = DIVIDE ( SUM ( 'GA Traffic'[Pageviews] ), SUM ( 'GA Traffic'[Sessions] ), 0 )

Best Regards,

Herbert