Mesure avec date relative

[janusd27]

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 

_NombreSollicitationLastMonth = CALCULATE([_NombreDeItemID]; DATESINPERIOD(Categorisations[Date_Creation];LASTDATE(Categorisations[Date_Creation];-1;MONTH)))

Pouvez vous m'aider sur cette recherche svp ?

Hello,
I am looking with a size to recover the number of requests, from the last calendar month (function identical to the relative filter, in the visual filters

Can you help me with this research please?

[Icey · Accepted solution]

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]

Thanks 🙂

[amitchandak]

I usually prefer datesmtd or totalmtd with calendar table.

Example

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last MTD (complete) Sales =  CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

[janusd27]

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]

The must Is ??

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

[janusd27]

I wrote :
_NombreSollicitationLastMonth = CALCULATE([_NombreDeItemID];DATESMTD(ENDOFMONTH(dateadd('Categorisations'[Date_Creation];-1;MONTH))))

Error Message:
MdxScript(Model) (11, 85) Erreur de calcul dans la mesure 'Categorisations'[_NombreSollicitationLastMonth] : Une colonne de date contenant des dates dupliquées a été spécifiée dans l'appel de la fonction « DATESMTD ». Cela n'est pas pris en charge.