Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Future and Past Date Filtering

Hi,    i´m looking for some help visualizing the data for the past 30 days, today and the future 30 days. Which formula do i need for this? Can i use the DATEDIFF formula? Or can i do it with this...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try meaures like

     

    Measure = calculate(sum(Sheet5[value]) filter(Sheet5,Sheet5[date]<=TODAY()+30 && Sheet5[date]>=TODAY()-30))

     

    Measure = calculate(sum(Sheet5[value]) filter(Sheet5,Sheet5[date]<=TODAY()+30 && Sheet5[date]>=TODAY()))

     

    Measure = calculate(sum(Sheet5[value]) filter(Sheet5,Sheet5[date]<=TODAY() && Sheet5[date]>=TODAY()-30))

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

Anonymous , Try meaures like

 

Measure = calculate(sum(Sheet5[value]) filter(Sheet5,Sheet5[date]<=TODAY()+30 && Sheet5[date]>=TODAY()-30))

 

Measure = calculate(sum(Sheet5[value]) filter(Sheet5,Sheet5[date]<=TODAY()+30 && Sheet5[date]>=TODAY()))

 

Measure = calculate(sum(Sheet5[value]) filter(Sheet5,Sheet5[date]<=TODAY() && Sheet5[date]>=TODAY()-30))