Hi everyone,
I am trying to build a balance sheet in a matrix visual showing the last month (i.e. October 2022 results) compared with December values of last year (i.e. December 2021) with the header reflecting Month & Year.
I have a date table with a date column marked as date.
I managed to calculate latest month and December last year's value through the following formulas.
The desired outcome is to get the result to work in one measure. Appreciate the help!
Solved! Go to Solution.
@Peter_Yaacoub , Try measure like
Last Month Today =
var _min = eomonth(today(),-2)+1
var _max = eomonth(today(),-1)
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))
Last Month Last year Today =
var _min = eomonth(today(),-1*month(Today())-1)+1
var _max = eomonth(today(),-1*month(Today()))
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))
@Peter_Yaacoub , Try measure like
Last Month Today =
var _min = eomonth(today(),-2)+1
var _max = eomonth(today(),-1)
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))
Last Month Last year Today =
var _min = eomonth(today(),-1*month(Today())-1)+1
var _max = eomonth(today(),-1*month(Today()))
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))
User | Count |
---|---|
112 | |
63 | |
60 | |
39 | |
37 |
User | Count |
---|---|
116 | |
66 | |
66 | |
65 | |
50 |