Forum Discussion

NT92's avatar
NT92
Regular Visitor
4 years ago

Date range slicer DAX help request

Hi , I’m developing a report in powerbi I have two slicers one slicer with Year& Month combined in Date hierarchy and another slicer with type as YTD & selected month & trailing12months I have to ca...
littlemojopuppy's avatar
littlemojopuppy
Community Champion
4 years ago

Hi NT92 

 

What you can do is create a measure that works like this...

SWITCH(
	SELECTEDVALUE(DisconnectedSlicerTable[FieldName]),
	"YTD", [Measure for YTD],
	"Selected Month", [Measure for Selected Month]
	--Repeat as necessary
)

Hope this helps!