Dax Formula

ooctaviano — Thu, 19 Nov 2020 21:49:44 GMT

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 last date selected on slicer

M34 Mes =

VAR _minDate3 = STARTOFMONTH(Calendario[Date])

VAR _maxDate3 = ENDOFMONTH(Calendario[Date])

return month(_maxDate3)

I'm trying to bring the budget for the month on the last date selected on slicer

Please advise

Omar Octaviano

Re: Dax Formula

amitchandak — Fri, 20 Nov 2020 02:03:37 GMT

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]))

topic Dax Formula in DAX Commands and Tips

Dax Formula

Re: Dax Formula