Issue with TotalMTD Calculation.

[AThakur1]

Hi, I am trying to calcuate MTD Consumption & using below dax. 

MTDConsumption = TOTALMTD(SUM(Consumption[Qty Consumed]),Consumption[Consumption Date])

In below image selected item was last consumed on 13 March'25.However its showing MTD consumption 110. 

Can you someone please assist and let me know what I am doing wrong?

[v-echaithra]

Hi @AThakur1 ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra.

[v-echaithra]

Hi @AThakur1 ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Chaithra.

[v-echaithra]

Hi @AThakur1 ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra.

[v-echaithra · Accepted solution]

Hi @AThakur1 ,

Try the below DAX,

MTD Consumption =
var_CurrentMonth = MONTH(TODAY())
var_CurrentYear = YEAR(TODAY())
var_Hasdatathismonth =
CALCULATE(COUNTROWS(Consumption),
FILTER(
Consumption,
MONTH(Consumption[Consumption Date]) = _CurrentMonth &&
YEAR(Consumption[Consumption Date]) = _CurrentYear
)
) > 0
RETURN
IF(Hasdatathismonth, TOTALMTD(SUM(Consumption[Qty Consumed]), 'Date'[Date]),BLANK()
It checks if the item has any consumption in April, and only then it shows MTD otherwise shows blank.

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

Thanks and Regards,
Chaithra E.

[AThakur1]

(Reposting.. not able to see my previous reply).

Thank you for the reply.

Below it the desired output. 

Tried both dax & they are calculating sum from prevoius months(whichever last date/month available) for highlited yellow items. As data for these items not avilabel for the month of Apr'25 in the dataset. 

Its same for MTD & YTD results, they calculating result considering last available date, if data for current month/year not available. However, total for both YTD/MTD is correct.

Data is coming from three table (item number is comman in all tables), 

1-Item master

2-Stock.

3-consumption. 

Have also tried creating calander & conneting date but same result. 

MTD Consumption = TOTALMTD(SUM(Consumption[Qty Consumed]),'Date'[Date])

[anilelmastasi]

Hello @AThakur1 ,

TOTALMTD works based on the current filter context. So, if your item isn't actively filtered in a visual or slicer, Power BI computes the total for all items for the month-to-date. You need to filter the calculation by item if you're expecting it per item, or clarify the context in your measure.

If you want to compute MTD for a selected item only:

MTDConsumption =
CALCULATE(
TOTALMTD(
SUM(Consumption[Qty Consumed]),
Consumption[Consumption Date]
),
ALLSELECTED(Consumption[Item]) -- or filter by a specific item
)

If this solved your issue, please mark it as the accepted solution. ✅

[AThakur1]

@anilelmastasi ,Thank you for reply!

Below is the desired output table.However, both dax calcuating total from the previous months (whichever is the last available month )for the highlited yellow rows, as these items not consumed in current month their data not availabel for Apr'25 in the dataset.

If i check MTD/YTD total it's correct, but in rows its cehcking data for all the items from item master.

Bleow data is coming from three tables:

Item no from item master.

Stock from Stock & consumption from consumption. 

Also,created calander used below formula but same result. :

MTD Consumption = TOTALMTD(SUM(Consumption[Qty Consumed]),'Date'[Date])

.