topic Re: SET ANALYSIS SUM WITH DATE in Water Cooler

SET ANALYSIS SUM WITH DATE

jmialoundama — Wed, 05 Feb 2020 21:45:29 GMT

Hello ,

I have a dimension called "Supplier Date" on which users can filter.

For example if the selected user selects the date of 12/30/2019, I would like to make the sum of supplier purchases <= 12/30/2019.

The user can choose any date from the supplier date dimension. This is why I would like to carry out a set analysis which calculates the sum of supplier purchases compared to the date that the user will select.

So if the user selects 01/31/2019 it will be necessary to calculate supplier purchases which are <= 12/31/2019

Re: SET ANALYSIS SUM WITH DATE

Taoufiq_Zarra — Tue, 17 Dec 2019 20:22:04 GMT

Hi,

Try this :

=sum({$<[Supplier Date]={"<=$(=Date(max([Supplier Date]),'MM/DD/YYYY'))"}>}[Supplier PURCHASES])

Re: SET ANALYSIS SUM WITH DATE

jmialoundama — Wed, 18 Dec 2019 08:50:02 GMT

Hi Taoufiq,

Thanks you so much for your answer, it's works like i want 🙂

Re: SET ANALYSIS SUM WITH DATE

jmialoundama — Wed, 18 Dec 2019 09:01:42 GMT

I have an other question, if i want to do set analysis between two , it seem like :

= sum({$<[Supplier Date]={">=$(=Date(min([Supplier Date]))<=$(=Date(max([Supplier Date]))"}>}[Supplier PURCHASES])

Re: SET ANALYSIS SUM WITH DATE

Taoufiq_Zarra — Wed, 18 Dec 2019 09:20:15 GMT

yes

Re: SET ANALYSIS SUM WITH DATE

jmialoundama — Wed, 18 Dec 2019 13:19:09 GMT

Ok thanks 🙂