Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Are you gonna use March 2018 static date?
Yes
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().