Today to Next 6 months

[sreddy47652]

Hi Folks,

I have Date column and certification completion status column. I need help to write dax to today to next 6 months certification due status.

[amitchandak · Accepted solution]

@sreddy47652 , You can measure/s like this one

calculate(sum(Table[Value]), filter(Table, Table[Date] >= Today()  && Table[Date]  <= eomonth(today(),6) ) )

or

calculate(sum(Table[Value]), filter(Table, Table[Date] >= Today()  && Table[Date]  <= date(year(today()),month(today())+6, day(today()) ) ) )