Forum Discussion
zawlh
Helper I
Helper IGrowth 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 ...
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
Super User
Super Userzawlh , 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))