Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

## Last 18 selected days values

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

2 REPLIES 2
Community Support

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!

Helper I

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 !

## Helpful resources

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors