Forum Discussion

Helper IV

9 years ago

I need help

Mesure 2015-2016 = CALCULATE(SUM(Factures[2015-2016]);FILTER(ALL(Factures);Factures[Mois.Date] >= DATE(2015;07;01) && Factures[Mois.Date] <= MAX(Factures[Mois.Date]))) Bonjour, J'aimerais rempla...

Need Help

austinsense

Impactful Individual

9 years ago

D'accord. You should make two formulas - You'll need to have a calendar table in your model.

Current Year (YTD)

Current Year (YTD) = CALCULATE([Revenue], DATESYTD(CalendarTable[Date]) )

Last Year (YTD)

CALCULATE([Current Year (YTD)],DATEADD(Calendar[Date],-1,YEAR) )

AlexGallet01

Helper IV

9 years ago

pour l'instant lorsque je les met en séparé tout fonctionne normalement mais des que je souhaite les réunir sour un même c'est le drame.

For the moment when I put them separated everything works normally but of the that I wish to join them to the same one it is the drama