Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Proud to be a Super User!
@bhurru , In case you need a measure slicer :
Rolling weeks data :
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
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |