Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sum between two dates

Hi,   In one of my reports I use TOTALMTD to give the monthly values of that month. However I need a daxformula that summarize a value between two dates (will be a static number throughout the repo...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi @Oscar1133 ,

    Here are 2 measures that can satisfy your need:

    Test bus salesmen=CALCULATE(SUM(ddd[RT Bus Salesmen]),DATESBETWEEN('Calendar table'[Date],DATE(2019,02,01),DATE(2019,02,28)))

    O

    Test bus salesmen=CALCULATE(SUM(ddd[RT Bus Salesmen]),FILTER(ALLSELECTED('Calendar table'),'Calendar table'[Date]>=DATE(2019,02,01) && 'Calendar table'[Date]<=DATE(2019,02,28)))

    Saludos
    Kelly
    Did I answer your question? Mark my position as a solution!

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi @Oscar1133 ,

Here are 2 measures that can satisfy your need:

Test bus salesmen=CALCULATE(SUM(ddd[RT Bus Salesmen]),DATESBETWEEN('Calendar table'[Date],DATE(2019,02,01),DATE(2019,02,28)))

O

Test bus salesmen=CALCULATE(SUM(ddd[RT Bus Salesmen]),FILTER(ALLSELECTED('Calendar table'),'Calendar table'[Date]>=DATE(2019,02,01) && 'Calendar table'[Date]<=DATE(2019,02,28)))

Saludos
Kelly
Did I answer your question? Mark my position as a solution!

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

excellent!! contribution!! papaaa!!