Sale Range

[prma7799]

Dear All,

I am getting Sale for before September from below expression

sum({<Date={"<$(=floor(monthstart(vToday)))"}>}[Sale])/100000

Now I want from Today to last 6 months Sale

Can you please advise

[miguelbraga]

See this:

Set Analysis for Rolling Periods

Best regards,

D.A. MB

[tresB · Accepted solution]

For sales of today since last 6 months try like:

sum({<Date={">=$(=monthstart(vToday,-6)) <=$(=today())"}>}[Sale])/100000

[trdandamudi]

May be as below:

=Sum({<Date= {"$(='>=' & Floor(MonthStart(vToday())-6) & '<=' & Floor(vToday())"}>} [Sale])/100000)

[Anil_Babu_Samineni]

If you want last 6 months Data

You can try this too

sum({< Date= {" <= $(=AddMonths(Today(),-6))"}>} Sale)

OR

sum({< Date= {" <= $(=MonthStart(Today(),-6))"}>} Sale)

OR

sum({< Date= {" <= $(=MonthStart(Today(),-6,0))"}>} Sale)

[prma7799]

I am using floor for default date