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 remplacer la fin de ma mesure (MAX(Facture[Mois.Date]) par une date précise mais sa ne fonctionne plus du tout lorsque je remplace cette fin par DATE(2016;06;31) et je ne comprend pas pourquoi. Hello, I would like to replace the end of my measure (MAX (Invoice [Mois.Date]) with a specific date but it no longer works at all when I replace DATE (2016; 06; 31) and I do not understand why

Ok let me just slow this whole thing down - I would recommend getting a book and reading it. This is the best selling book on the topic (https://www.powerpivotpro.com/the-book/) You're missing some of the fundamentals of how to put a data model together and that's messing up your formulas / making your formulas impossble. If you wanna speak to someone who's awesome at this who also speaks french then I can make a recommendation - Tristan Malherbe is excellent.

hi AlexGallet01 Try in this way: 1. A Calendar table with Fiscal Year, and Fiscal Month Number Columns Fiscal Year = IF ( MONTH ( 'Calendar'[Date] ) <= 6, 'Calendar'[Year], 'Calendar'[Year] + 1 )Fiscal Month = IF ( MONTH ( 'Calendar'[Date] ) <= 6, 'Calendar'[Month] + 6, 'Calendar'[Month] - 6 )2. A new Measure ValuesThisYear = CALCULATE ( SUM ( Table1[Value] ), DATESBETWEEN ( 'Calendar'[Date], CALCULATE ( FIRSTDATE ( 'Calendar'[Date] ), FILTER ( ALL ( 'Calendar' ), 'Calendar'[Fiscal Year] = MIN ( 'Calendar'[Fiscal Year] ) ) ), LASTDATE ( 'Calendar'[Date] ) ) )3. Insert a slicer 4. Insert a Visual Clustered Column Chart 5. If you need to sort the months Select MonthN and Sort by Fiscal Month

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) )

I need help | Microsoft Fabric Community

20 Replies

austinsense
Impactful Individual
9 years ago
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?
- AlexGallet01
  Helper IV
  9 years ago
  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
  - 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
I don't undertand how use your solution it is possible to use my measure and replace MAX(Facture[Mois.Date]) by DATE(2016;06;31) and have the same result ????

Forum Discussion

I need help