Forum Discussion

janusd27's avatar
janusd27
Frequent Visitor
6 years ago
Solved

Mesure avec date relative

  Bonjour, Je cherche avec une messure à récupérer le nombre de sollicitations, du derniers mois civil (fonction identique au filtre relative, dans les filtres visuels  _NombreSollicitationLas...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi janusd27 ,

     

    If I understand you correctly, what you want to do is to calculate total of last month based on slicer.

    Please check if this is what you want:

    Last Month Total Measure = CALCULATE ( SUM ( 'Table'[Value] ), PREVIOUSMONTH ( 'Calendar'[Date] ) )

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

janusd27's avatar
janusd27
Frequent Visitor
6 years ago

I wrote 

_NbrSollicitionLastMonth = CALCULATE(DISTINCTCOUNT(Categorisations[Changements]);DATESINPERIOD(Calendrier[Date];LASTDATE(Calendrier[Date]);1;month)) 


But he recovered the sum of the last 6 calendar months instead of the sum of the last calendar month
janusd27's avatar
janusd27
Frequent Visitor
6 years ago

The must Is ??

_NombreSollicitationLastMonth = TOTALMTD(SUM(Categorisations[CHG_1]);PREVIOUSMONTH(Aujourd'hui ?))