Forum Discussion

sarikei's avatar
sarikei
Helper I
3 years ago

Selection from Slicer

Hi,   I have a Slicer in the report. Assign the Date as Field to this. Choose “Between” as type of this Slicer, so I have “From – To” display for the date selection. I want to create a measure to...
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

sarikei Try:

 

Measure =
  VAR __Min = MIN('SlicerTable'[Date])
  VAR __Max = MAX('SlicerTable'[Date])
  VAR __Min1YearAgo = DATE(YEAR(EOMONTH(__Min,-12)),MONTH(__Min),DAY(__Min))
  VAR __Max1YearAgo = DATE(YEAR(EOMONTH(__Max,-12)),MONTH(__Max),DAY(__Max))
  VAR __Result = SUMX(FILTER(ALL('Table'),[Date] >= __Min1YearAgo && [Date] <= __Max1YearAgo),[Column])
RETURN
  __Result

 

sarikei's avatar
sarikei
Helper I
3 years ago

Thanks Greg_Deckler.

can you tell me what is that [Column] means in the following?

 

  VAR __Result = SUMX(FILTER(ALL('Table'),[Date] >= __Min1YearAgo && [Date] <= __Max1YearAgo),[Column])

 

  • sarikei's avatar
    sarikei
    Helper I
    3 years ago

    Hi,

    I can't get it work. I dont know what is the [Column] represent? I have error message if I enter [Column]. Pleaes help. Thanks.