Forum Discussion

zawlh's avatar
zawlh
Helper I
4 years ago
Solved

Growth Rate and Number between two dates

Hello. I have a data for everyday record through a year, [Total Members] column is a running total column.   What I want to know is that is there any DAX formula to calculate the value difference ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    zawlh , assume you are selecting a date range, You can try measure like

     

    Measure =
    Var _max = maxx(allselected(Date),Date[date])// Or take today
    Var _min = minx(allselected(Date),Date[date])
    return
    calculate([Value Measure], filter(all(Date),Date[Date] =_max)) - calculate([Value Measure], filter(all(Date),Date[Date] =_min))

amitchandak's avatar
amitchandak
Super User
4 years ago

zawlh , assume you are selecting a date range, You can try measure like

 

Measure =
Var _max = maxx(allselected(Date),Date[date])// Or take today
Var _min = minx(allselected(Date),Date[date])
return
calculate([Value Measure], filter(all(Date),Date[Date] =_max)) - calculate([Value Measure], filter(all(Date),Date[Date] =_min))

zawlh's avatar
zawlh
Helper I
4 years ago

I tried your solution and it works. Then, I try a little bit change and I finalized with this DAX.

 
calculate(SUM(Table[Columne_Name]),
   filter(all(Table[Date]),
   Table[Date] = DATE(2021,06,30)
  )
) -
calculate(SUM(Table[Columne_Name]),
   filter(all(Table[Date]),
   Table[Date] = DATE(2021,06,20)
  )
)
 
Thank you for your help.