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!

az38's avatar
az38
Community Champion
6 years ago

hi Anonymous 

try without filter and use more appropriate date statement, like

 

= CALCULATE( SUM(ddd[RT Bus Salesmen]); DATESBETWEEN(ddd[Date];DATE(2019;2;1); DATE(2019;2;28)) )