Period of sales of current month compared with last month acording to current month progress

how to show a column that gets the percentage of growth or decline of sales of current month compared with previous period of last month?

for example today is feb 18, I would like the expression to get the sales of current month and then compare it with the same period of last month.

(jan 1 - jan 18)

to get sales of current month in a slice Im using this 

EOMONTH([Date], 0) = EOMONTH(TODAY(), 0) 

any help is much appreciate it.

0 1 66
1 REPLY 1

For last month's slice, please try an expression, something like 

AND(EOMONTH([Date], 0) = EOMONTH(TODAY(), -1) ,

DAY([Date])<=DAY(TODAY()))

 

 

Top Labels in this Space