Forum Discussion
Create a rolling date measure for date
I have created a measure for a date field Week_CurrentTransCount = ( VAR _Cuur_start = Max('Date'[Current Date]) Var _Rolling_5_Days = CALCULATE(SUM(Final[count]),DATESINPERIOD(DATE(Max('Dat...
Anonymous
it looks like you have incorrect syntax.
try
CurrentTransCount = ( VAR _Cuur_start = Min('Date'[Current Date]) VAR _Curr_END = Max('Date'[Current Date]) return calculate(SUM(Final[TransCountnUm]), Final[Date] >= _Cuur_start, Final[Date] <= _Curr_END )or
CurrentTransCount = ( VAR _Cuur_start = Min('Date'[Current Date]) VAR _Curr_END = Max('Date'[Current Date]) return calculate(SUM(Final[TransCountnUm]),FILTER(ALL(FInal),Final[Date] >= _Cuur_start && Final[Date] <= _Curr_END ))
Greg_Deckler
Community Champion
Community ChampionI would just do:
Week_CurrentTransCount =
VAR _Curr_start = Max('Date'[Current Date])
VAR _Curr_END = (_Curr_start - 5)
return
SUMX(FILTER(Final,Final[Date] >= _Curr_start && Final[Date] <= _Curr_END ),Final[count])I am not able to get any data in my measure.Although it is correct syntax wise .
The measures i used for first 2 columns are working
CurrentTransCount =
(
VAR _Cuur_start = Min('Date'[Current Date])
VAR _Curr_END = Max('Date'[Current Date])
return
calculate(SUM(Final[TransCountnUm]),Final[Date] >= _Cuur_start && Final[Date] <= _Curr_END ))
- az38
Anonymous
it looks like you have incorrect syntax.
try
CurrentTransCount = ( VAR _Cuur_start = Min('Date'[Current Date]) VAR _Curr_END = Max('Date'[Current Date]) return calculate(SUM(Final[TransCountnUm]), Final[Date] >= _Cuur_start, Final[Date] <= _Curr_END )or
CurrentTransCount = ( VAR _Cuur_start = Min('Date'[Current Date]) VAR _Curr_END = Max('Date'[Current Date]) return calculate(SUM(Final[TransCountnUm]),FILTER(ALL(FInal),Final[Date] >= _Cuur_start && Final[Date] <= _Curr_END ))