Forum Discussion

ooctaviano's avatar
ooctaviano
Frequent Visitor
5 years ago

Dax Formula

I have this measure formula but for some reason it does not work M35 Budget Month= sumx(FILTER(Budget,(Budget[Month] = [M34 Month])),Budget[Goal Month])   Measure 34 only brings month based on la...
amitchandak's avatar
amitchandak
Super User
5 years ago

ooctaviano , Not very clear, what output you want. But with help from Date table and time intelligence you can get.

 

Refer these examples

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))
this month =MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH('Date'[Date])))
last MTD (complete) Sales =  CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))
previous month value =  CALCULATE(sum(''Table''[total hours value]),previousmonth('Date'[Date]))