Dynamic filter condition of a measure

[bhurru]

Hi, I have couple of measures like Calculate(<expr>,Datesinperiod(CalenderDate,<startDate>,Number of interval,Interval)).

Also I have time period slicer having 4 values

8Weeks

26 Weeks

2 Quarters

24 Months

Now I want above measure to dynamically change DatesinPeriod filter according to the TimePeriod Slicer selection user make.

I know one approach by creating measures for all time period and then using Selectedvalue make them dynamic. This is all throughout the communities. My problem is by this approach I  have to create 16 measures for one metric and there are 6 metric.  

16 measures for one metric as in When user select 8 Weeks from Time Period slicer, then I need to show Curr4Weeks, Prev4Weeks,Delta and %Change. Hence 4*4(4 time period) = 16. 

Is it possible to only make this happen by dynamically writing DatesinPeriod filter condition in measure definition in some way ? Or if there is some other way to achieve this.

[vanessafvg]

switch statement() might work

https://www.thedataschool.com.au/danica-hui/switching-measures-and-titles-dynamically-in-power-bi/

[amitchandak]

@bhurru , In case you need a measure slicer :

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

Rolling weeks data :

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...

https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3

select 1 week/date and display more week

user relative date slicer:https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

or

use this option : https://www.youtube.com/watch?v=duMSovyosXE