Dynamic Slicer basis user inputs on date

Question

Hello Community - Need help with suggestions/solutions

I have a pbix with multiple tables (eg. sales, Hours, Volume, etc...) all linked to another "Date" table with the "dates" as a unique identifier. All measure have been consolidated into another table for easier reference.

Help Required - I am using a date slicer from the "Date" table, which currently has the option to select "From" & "To" dates (between option); however what I am looking for is the "From" date to be disabled and users get to select only from the "To" date and basis this selection, the "From" date should substract 28 days/4 weeks/n dates (though the "From" date should be disabled, it should still show the "From" date)

I've searched the community however not able to see one on this topic (maybe am using the wrong keywords).

Any help on suggestions/solutions would be greatly appreciated

Edit - Forgot to mention, I am trying to achieve this in a "Table Matrix". I was able to work around this on the chart visuals.

anonymous · Accepted Answer

Hi&nbsp; WYads&nbsp;,
I created some data:

Here are the steps you can follow：
1. Create calculated table.
Date = DISTINCT('Table'[Date])

day_table =
DISTINCT('Date'[Day])

week_table =
DISTINCT('Date'[week])

2. Create measure.
Flag =
var _selectday=SELECTEDVALUE('day_table'[Day])
var _selectweek=SELECTEDVALUE('week_table'[week])
var _max=MAXX(ALLSELECTED('Table'),[Date])
return
SWITCH(
    TRUE(),
 HASONEVALUE('day_table'[Day])&amp;&amp;NOT( HASONEVALUE('week_table'[week])),
IF(
MAX('Table'[Date])&gt;=
DATE(YEAR(_max),MONTH(_max),DAY(_max)-_selectday)&amp;&amp;MAX('Table'[Date])   &lt;=_max,1,0),
HASONEVALUE('week_table'[week]),
IF(
MAX('Table'[Date])&gt;=
DATE(YEAR(_max),MONTH(_max),DAY(_max)- 7 *_selectweek)&amp;&amp;MAX('Table'[Date])   &lt;=_max,1,0))
3. Place [Flag]in Filters, set is=1, apply filter.