powerbi - TOTALMTD Measure is not working in Power BI Dax -


i creating power bi report have 1 date table , table, in have 2 columns date column , daily target. need create mtd measure sum current month date daily targets. using formula not returning correct result. here formula using:

    mtd-measure = calculate(sum(groupbytableformtd[max daily target]),datesmtd(tbldate[date])) 

here data table.

enter image description here

please me write mtd measure. thankful you.

msdn: totalmtd function (dax)

mtd-measure = totalmtd(sum(groupbytableformtd[target]),groupbytableformtd[date],all(table5)) 

enter image description here


Comments

Popular posts from this blog

'hasOwnProperty' in javascript -

python - ValueError: No axis named 1 for object type <class 'pandas.core.series.Series'> -

java - How to provide dependency injections in Eclipse RCP 3.x? -