Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Team,
I have to show last 18 week from selected date and selected day.
There will be 2 sliceres week number and weekday.
User will select week number(19 2024) & Weekday (Monday) my result should show only monday values of last 18 weeks.
Please help me.
Thanks !
Rakesh
Hi @raassd ,
Please try:
Use a DAX measure to calculate the selected date based on the week number and year selected by the user.
Selected Date =
CALCULATE(
MAX(DateTable[Date]),
FILTER(
ALL(DateTable),
DateTable[Year] = SELECTEDVALUE(SlicerYearTable[Year]) &&
DateTable[WeekNumber] = SELECTEDVALUE(SlicerWeekNumberTable[WeekNumber])
)
)
Create a measure, which means that the selected date and the sales volume of the past 18 weeks started in the past 18 weeks.
Last 18 Weeks =
CALCULATE(
[Sales],
FILTER(
ALL(DateTable),
DateTable[Date] <= [Selected Date] &&
DateTable[Date] > DATEADD([Selected Date], -18, WEEK) &&
DateTable[Weekday] = SELECTEDVALUE(WeekdaySlicer[Weekday])
)
)
You can replace the 'Sales' with the data you want to calculate.
I would appreciate it if you could provide me with example data for testing and remember to erase your private information.
If you have other questions, please contact me at any time.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Thanks for your Help,
I need to show the Output as below.
User will select week from Slicer and Day from other slicer it should only show that day value for last 10 weeks.
Thanks !
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |