topic SET ANALYSIS in App Development

SET ANALYSIS

MR_Challaa — Thu, 26 Aug 2021 05:57:39 GMT

I HAVE ONE YEAR DATA.

HOW TO GET SUM OF SALES FOR THE LAST 6 MONTHS IN A TEXT OBJECT.

AND

WE SHOULD NOT DO ANY CHANGES IN SCRIPT LEVEL.

REGARDS

lironbaram — Thu, 26 Aug 2021 06:41:54 GMT

Hi,
You can use something like this.
Assuming you have a Date field called DateField.

sum({<DateField={">=$(=monthstart(addmonths(max(DateField),-5))"}>}Sales)

anthonyj — Thu, 26 Aug 2021 06:48:03 GMT

Hi,

You can add a measure in you text object without any changes to the model. The measure would look like this.

sum({$<DateField={">=$(=monthstart(today(0),-5))"}>}Sales)

Regards

Anthony