Forum Discussion
I need help
Make your life a little easier and try this if you want a fixed set of dates (DATESBETWEEN) https://msdn.microsoft.com/en-us/library/ee634557.aspx
Bigger question, why do you want use fixed dates, that doesn't seem very useful for slicing and dicing?
Je souhaite faire un cumul de donées monétaire sur une année et ceci pour chaque années et ensuite pouvoir les comparere entre eux. Et lorsque je fais un datesbetween plus rien ne fonctionne
I wish to accumulate monetary data over a year and this for each year and then be able to compare them. And when I do a datesbetween nothing works anymore
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) )
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
