Set Expression Month Condition

[khanashique]

Hi Experts,

I am facing an issue in the following looking numbers for last month, while adding the set expression in graph:

Dimension = Date

Measure = Sum({<Category = {'Books'},Month = {"$(=Month(Today())-1)"}>}OrderQty)

Thanks,

MAK.

[Channa]

bro you have date-

just do date(date,'mm/dd/yyyy')

just use below

vMonthStart=monthstart(AddMonths(Today(),-1))

vMonthEnd=monthend(AddMonths(Today(),-1))

Measure = Sum({<Category = {'Books'},date ={">=$(vMonthStart)<=$(vMonthEnd)"}>} >}OrderQty)

[pradosh_thakur · Accepted solution]

Hi @khanashique 

With your sample data this will work.

= Sum({<Category = {'Book'},DATE ={"=month(today()-30)=Month(DATE)"}>} OrderQTY)

[pradosh_thakur]

This will work as well

= Sum({<Category = {'Book'},DATE ={"=month(addmonths(today(),-1))=Month(DATE)"}>} OrderQTY)

Things to note

Your category is 'Book' and not 'Books' in the sample data. OrderQTY is not OrderQty and please check your date field name.

Let me know if you need qvf as well.

[Channa]

I attach  qvF

i get 8852000

[khanashique]

Thanks Pradosh....the expression given by you worked...

[khanashique]

Thanks Channa...