Total to Date Vs Total by the end of the month

[Mannai]

Hello everyone !!

So i'm currently working in a HR database where i need to show total entry by today and for the rest of the month
FOR EXAMPLE : 16/02/2022 we have 14 new employees And by the end of the month which is 28th of february the cumulative total will be 25. I tried to calculate it with ENDOFMONTH() but when i put my slicer to the 16th of february it shows the same SUM which is 14 in both cards

Thanks for your time 🙂 

[Mannai · Accepted solution]

Thank you for your response 
 i actually resolved using this method :

Terminated by end of month =

CALCULATE( 'effectif total'[Terminated Employees],DATESBETWEEN('Date'[Date],MIN('Date'[Date]),MAX('Date'[End of Month])))

and when i filter i get the correct numbers

[amitchandak]

@Mannai , with help from time intelligence

MTD and full month

examples

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

This month Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH('Date'[Date])))