Current Month

[#1]

I want to reference the current month in my expression, so that I can sum sales that are current month -1,-2 etc

Can this be done?

[#2]

Thanks. works perfect.

[srini]

Hi Swuehl,

I have tried this expression for my data to sum till date forecasting. but it is not working it is only showing 0.

My Data:

Year	Month	Units
2019	Mar	100
2019	Apr	200
2019	May	300
2019	Jan	100
2019	Dec	100
2019	Aug	100
2019	Jan	100
2019	Feb	100
2019	Apr	200
2019	Sep	300
2019	Oct	200
2019	Mar	300

Expression: sum({<[Month]={"<=$(=Month(today()))"}>}[Units])

but gives 0