cancel
Showing results for
Did you mean:
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
Highlighted
Frequent Visitor

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

awesome thank you

Announcements

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

#### January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

#### Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors