cancel
Showing results for
Search instead for
Did you mean:
Frequent Visitor

## Variations in Matrix (Last day of each month)

Hi gurus,

I have matrix that look like this:

I want to easily identify the biggest variations between the end of each month (if you have any tips on best visuals for this case, it'd be plus).

I want to build a matrix like this:

Showing the variations from the past period to the next one.

1 ACCEPTED SOLUTION
Community Support

You can create a measure to compare with endofmonth and end of previous month.

ENDOFMONTH function (DAX) - DAX | Microsoft Docs

Measure =
var eomvalue = CALCULATE(SUM([Value]),ENDOFMONTH('Table'[Date]))
var pre_eom_value =CALCULATE(SUM([Value]),ENDOFMONTH(PREVIOUSMONTH('Table'[Date])))
Return eomvalue - pre_eom_value

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

1 REPLY 1
Community Support

You can create a measure to compare with endofmonth and end of previous month.

ENDOFMONTH function (DAX) - DAX | Microsoft Docs

Measure =
var eomvalue = CALCULATE(SUM([Value]),ENDOFMONTH('Table'[Date]))
var pre_eom_value =CALCULATE(SUM([Value]),ENDOFMONTH(PREVIOUSMONTH('Table'[Date])))
Return eomvalue - pre_eom_value

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

## Helpful resources

Announcements

#### Launching new user group features

Learn how to create your own user groups today!

#### Check it Out!

Click here to read more about the November 2021 Updates!

#### Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors