Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

DAX Measure for totl SUM between two dates

Hello guys,   I'm pretty new to DAX and whant a measure that calculates the value of declaraties.The hard thing to me are the arguments:   The measure must calculate only the values where the tim...
v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

Based on my test, you could refer to below steps:

Sample data:

Create a calculated column:

Date diff = DATEDIFF('Table1'[Start Date],'Table1'[End Date],DAY)/365

Create a measure and you could see the result:

Sum Value = CALCULATE(SUM('Table1'[Value]),FILTER('Table1','Table1'[Date diff]<=2))

You could also download the pbix file to have a view:

https://www.dropbox.com/s/mn30j112ecqvo1b/DAX%20Measure%20for%20totl%20SUM%20between%20two%20dates.pbix?dl=0

 

Regards,

Daniel He

 

Fuzel's avatar
Fuzel
Frequent Visitor
7 years ago

Hey v-danhe-msft 

 

How would the structure of DAX change if I say that my end date is in a differen table?

I have to sum the demand for a part during the timeline of RTS_date + 90. For example a part X has an RTS 01/01/2000 then I have to calculate the total demand for this part using period from demand table which is RTS date + 90 days. SO basically sum the demand from demand table where the period is before 03/01/2000(assumed 30 days each month)

 

I have attached the table pic for two different tables.

Demand Table: