previous month volume value

[kimboqlik]

Hello!!

My date expression is yearmonth and my volume is volume.

I would like a simple method of displaying in my table not the load script

previous month volume. It is not working for me because the date should be in the format of yearmonth.

[Saravanan_Desingh]

Can you try this?

=Count({<volume= {"=Date(MonthStart(yearmonth),'MMM-YY')=Date(MonthStart(AddMonths(Today(),-1)),'MMM-YY')"}>} volume) 

[Bubskim]

Hello,

Thank you for responding!

Can you try again please? And explain what your logic means? 

the volume portion works however the date format does not. 

My date format is like so 

=[xxxnameoftable.autoCalendar.YearMonth]

How do you propose adding that to the syntax below?

[kimboqlik]

Hello,

Thank you for responding!

Can you try again please? And explain what your logic means? 

the volume portion works however the date format does not. 

My date format is like so 

=[xxxnameoftable.autoCalendar.YearMonth]

How do you propose adding that to the syntax below?