Condition Date

[MauriceLudo]

Hi,

Please I would like to calculate the sum of sales before and after March 2018:

- if date > March 2018 : sum({<[Produits/Services]={'NSS & CCD '}>}[VENTE PRIS])

- if Date < March 2018 : sum({<[Produits/Services]={'NSS'}>}[VENTE PRIS])

please what is the best solution

Thank you

Best regards

Maurice

[HarishG]

Are you gonna use March 2018 static date?

[MauriceLudo]

Yes

[HarishG]

May be this should work from what i understood with your requirement :

if(Max(Date)< 01-March-2018, sum({<[Produits/Services]={'NSS'}>}[VENTE PRIS]),

sum({<[Produits/Services]={'NSS & CCD '}>}[VENTE PRIS])).

or

if(Max(Date)< '01-March-2018', sum({<[Produits/Services]={'NSS'}>}[VENTE PRIS]),

if(Max(Date)>= '01-March-2018', sum({<[Produits/Services]={'NSS & CCD '}>}[VENTE PRIS])).

you need to change the march 2018 as per your Calendar date format. And instead of Max(Date), you can use Today().