Forum Discussion
visheshjain
Impactful Individual
Impactful IndividualFilter Slicer from Measure values
Hello eveyone,
I have 3 tables. Calendar, Sale and Parameter.
Parameter has values ranging from 1-24, which are the number on months I want to go back.
I am trying to filter a slicer which has ...
lbendlin
Super User
Super UserYour measure are a little too complex. Use these instead:
1 Step = EOMONTH(CALCULATE ( MAX ( 'Sales'[Sale Date] ), ALL () ),-1)
2 Step = EOMONTH([1 Step], - [Parameter Value] ) + 1
visheshjainImpactful Individual
Impactful IndividualHi lbendlin,
Changed the measures but still, its not working with filtering the slicer.
Attaching my file again.