Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Today to Next 6 months

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.
Data Protection
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , 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()) ) ) )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , 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()) ) ) )