SET ANALYSIS SUM WITH DATE

[jmialoundama]

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

[Taoufiq_Zarra · Accepted solution]

Hi,

Try this :

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

[jmialoundama]

Hi Taoufiq, 

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

[jmialoundama]

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])

[Taoufiq_Zarra]

yes

[jmialoundama]

Ok thanks 🙂