Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |