Variations in Matrix (Last day of each month)

[uie07923]

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.

[V-pazhen-msft · Accepted solution]

@uie07923 

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.