TotalQTD,TotalMTD not working as expected

[shashed]

My data is weekly and has multiple 'type'. For date variable, I have created a 'date' column with start of each week. 

Sample Data:

My objective is to get MTD/QTD for each of the type separately and so tried to use the following DAX:

I have tried by having Date table separately as well and creating a relationship using week_id, but the outcome (new column) is  same as follows: (i.e. it is not summing up)

 expected outcome:

If someone can guide me with the above regards, that'd really helpful!

[v-yadongf-msft · Accepted solution]

Hi @shashed ,

Please try following DAX to create a new column:

Expected qtd = CALCULATE(SUM('Table'[Value]),FILTER('Table', 'Table'[Week] <= EARLIER('Table'[Week]) && 'Table'[Type] = EARLIER('Table'[Type]) && 'Table'[Quarter] = EARLIER('Table'[Quarter])))

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[shashed]

This works! Thanks!