Forum Discussion

harshagraj's avatar
harshagraj
Post Partisan
6 years ago

To switch between months

Hi all, Please help me to the achieve the below. I have to use slicer(Report Date). I have measures as Tools, Projects etc. In Slicer if i select Jan it should filter Jan and show in 1st view and  i...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

harshagraj , Not very clear. The only thing I can suggest is to take min value as a filter in one measure and max value as a filter in another measure. But there are a lot of ifs buts

 

Measure 1=
var _min = minx(Table,Table[Month])
return
calculate(Table[Value],filter(Table,Table[Month]=_min))

Measure 2 =
var _max = maxx(Table,Table[Month])
return
calculate(Table[Value],filter(all(Table),Table[Month]=_max))