cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Compare Daily Values to their respective Monthly average

Hi I have a simple table with daily weather data, along with a standard date table.
I want to put up a matrix or table visual where I list daily temperature value in one column and average value for that month in another column.

Matrix Visual

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: Compare Daily Values to their respective Monthly average

Hi @gmalekar ,

You can try to use the following measure formulas if they meet for your requirement:

``````Daily =
VAR currDate =
MAX ( table[Date] )
RETURN
CALCULATE (
SUM ( table[Amount] ),
FILTER ( ALLSELECTED ( Table ), [Date] = currDate )
)

Monthly AVG =
daily
=
VAR currDate =
MAX ( table[Date] )
RETURN
CALCULATE (
AVERAGE ( table[Amount] ),
FILTER (
ALLSELECTED ( Table ),
YEAR ( [Date] ) = YEAR ( currDate )
&& MONTH ( [Date] ) = MONTH ( currDate )
)
)
``````

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
2 REPLIES 2
Community Support Team

## Re: Compare Daily Values to their respective Monthly average

Hi @gmalekar ,

You can try to use the following measure formulas if they meet for your requirement:

``````Daily =
VAR currDate =
MAX ( table[Date] )
RETURN
CALCULATE (
SUM ( table[Amount] ),
FILTER ( ALLSELECTED ( Table ), [Date] = currDate )
)

Monthly AVG =
daily
=
VAR currDate =
MAX ( table[Date] )
RETURN
CALCULATE (
AVERAGE ( table[Amount] ),
FILTER (
ALLSELECTED ( Table ),
YEAR ( [Date] ) = YEAR ( currDate )
&& MONTH ( [Date] ) = MONTH ( currDate )
)
)
``````

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Frequent Visitor

## Re: Compare Daily Values to their respective Monthly average

awesome thank you

Announcements

#### Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

#### Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors