Hi, in one table I have all sales, I can compare sales from selected year and previous year, my problem is with actual year, I want to summerize previous year sales only to the same date as today but last year:
In this example I want sales last year until november, and when I will have december sales, I wants only too last year december sales.
Solved! Go to Solution.
What formula are you using for your measures?
I had some success with the following:
Ventes Total YTD = TOTALYTD(SUM('Sales'[Ventes]),'Dates'[Date]) Ventes Total Annee Pre YTD = TOTALYTD(SUM('Sales'[Ventes]),SAMEPERIODLASTYEAR('Dates'[Date]))
Proud to be a Datanaut!
Hi Phil, I tested yoyr formulas and it's not working for me.
My formulas are:
Ventes Total YTD = CALCULATE(Ventes[Ventes];DATESYTD(Calendrier[Date];"30/09"))
Ventes Total Année Précédente YTD = CALCULATE(Ventes[Ventes Année Précédente];DATESYTD(Calendrier[Date];"30/09"))
Please note I calculate according to fiscal year from oct. to sept.
You are missing the SUM function. Try this
Also, ensure that in your visual, you draf Year/months/days from the Calendar table.
Please make sure that you dragged [Date] field from calendar table, rather than your source table 'Ventes'.