Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear All,
How to create Dynamic Last N Weeks based on Fiscal_Week number, when Fiscal Week value in slicer is selected, in matrix visual or any pivot visual, Selected week + last 3 weeks should appear
Below
I have created Matrix Visual which contains details below -
On Rows - Product-L1
On Colums - Fiscal Week
Values - Efficiency
Below Screenshot
Then i created Matrix Visual using these colums, screensot below -
Above image i have selected 202033, 32, 31, 30 manually
Outcome - Now if i select 202033 automatically visual should show 202033, 20232, 202031, 202030
DataSet
@Anonymous - Replying from your PM. First, some sample data in a format that can be copied would be very helpful. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.
That being said, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
You should be able to figure out the last 4 weeks and only return values for those weeks, which should automatically exclude all of the other weeks in your matrix visual.
@Greg_Deckler - as you said i want in this way
"You should be able to figure out the last 4 weeks and only return values for those weeks, which should automatically exclude all of the other weeks in your matrix visual."
Files below-
Sample Data and pbxi file
Try something like this
Last 4 WEEK var _max_week = max(Fiscal Week) var _date = calculate(max(date),all([Fiscal Week]),[Fiscal Week]=_max_week) var _min_week = calculate(min(Fiscal Week),[date]= datediff(date,-28,day) return calculate(sum(x),all([Fiscal Week]), [Fiscal Week] >=_min_week and [Fiscal Week] <=_max_week)
Getting error amit - screenshot below
in third one in place of _date_ use vwReportinData[created_on]
i have only createddate column as below snap,
As i dont have created_one column, can you help me understand about this line "in third one in place of _date_ use vwReportinData[created_on]"
also can you please re-frame query and send it
Oh, you have created_date, copy from image in
third one in place of _date_ use vwReportinData[created_date].(Third in the sequence)
In case it does not work, paste formula, not image.
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |