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
Highlighted
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
Highlighted
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