Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi There,
I have a column called "Fiscal Week Start" in week increments.
I have another column called "Actual Sales".
I want to somehow have a slicer that will look at the "Fiscal Week Start" column and take the most recent date/row that
has a total > than 0 in the "Actual Sales" column. I want to do this for the latest Week, 4 Weeks, 12 weeks and 52 weeks.
So for instance the slicer would say L52, L24, L12, L4 , LW...
LW would only show 7/23/2023 sales, L4 would only show sales for the data in the rows with dates 7/23, 7/16, 7/09, 7/02
Power BI Time Period Help.xlsx
Thanks!
For your reference.
Step 1: I made a parameter table 'Week List'.
Step 2: I made a calendar table.
Step 3: I made a relastionship.
Step 4: I made some measures.
Step 5: I made a slicer.
Sorry.
I added a column below...
I made a measure and 2 columns.
Thanks for trying to help out!
Unfortunately, I would need only the dates that had above a 0 in the "actual sales column". At least the way I have the formula, It is just taking the latest date in my table.
Also, I am trying to get a slicer that doesnt take 4 weeks ago, but the last 4 weeks in summation/aggregate.
So L4 would not just be June 8th 2024 in the below example, but the 3 weeks above it as well.
THank you
User | Count |
---|---|
94 | |
90 | |
79 | |
77 | |
71 |
User | Count |
---|---|
116 | |
106 | |
88 | |
64 | |
63 |