Calculate prior month sales without a Date table
Revenue PM = | |
var prior_month_start_date = EOMONTH( MIN ( Sales[Date] ), -2 ) + 1 | |
var prior_month_end_date = EOMONTH( MIN ( Sales[Date] ), -1 ) + 1 | |
RETURN | |
CALCULATE( | |
SUM ( Sales[Revenue] ), | |
FILTER ( | |
ALLSELECTED ( Sales ), | |
Sales[Date] >= prior_month_start_date && Sales[Date] < prior_month_end_date | |
) | |
) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment