CODEWITHSUNDEEP
powerbidax
Farrukh Cheema
Farrukh Cheema

Reputation: 85

TOTALMTD Measure is not working in Power BI Dax

I am creating a Power BI report where I have 1 Date table and another table, in which I have 2 columns as Date Column and Daily Target. I need to create a MTD Measure which will sum the current month to date daily targets. I am using this formula but it is not returning a correct result. Here is the formula I am using:

    MTD-Measure = CALCULATE(SUM(GroupByTableForMTD[Max Daily Target]),DATESMTD(tblDate[Date]))

Here is my Data Table.

enter image description here

Please help me to write a MTD measure. I will be very thankful to you.

Upvotes: 0

Views: 3847

Answers (1)

user5226582
user5226582

Reputation: 1986

MSDN: TOTALMTD Function (DAX)

MTD-Measure = TOTALMTD(SUM(GroupByTableForMTD[target]),GroupByTableForMTD[date],All(Table5))

enter image description here

Upvotes: 0

Related Questions