Forum Discussion
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...
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.
Icey
Community Support
Community SupportHi 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.
Thanks 🙂