Selected Value based Last 7 days value required

[itsranga]

Hi,

  I have a 3 table

1. Table1

2. Table2

3. Calender

Relationship  

In power bi page i have 2 table first table for Table1 vallues ,  2nd table for Table2 values

Actual Data:

if i click first table any rows i need to filter 2nd table selected value to last 7 days value need to show on the 2nd table

Selected value based start date and End Date DaX

Filter_StartDate = SELECTEDVALUE(Table1[CreatedDate])

Filter_EndDate = [Filter_StartDate]-7

if i select first table any row i need to show case the 2nd table selected date to last 7 days value

exaple- if i selected first row created date is 1/20/2025  i need to show the 2nd table created date 1/20/2025 to 1/12/2025 values 

how to achive in DAX

[itsranga]

 @v-zhangtin-msft   

if its static value means this measure woking suppose dynamically selected value means its not working
for example in this measure

above picture highlighted i put 6 as a static values  its working

if i try to filter dynamic value, i have dates between slicer, i have start date and end date im using one Measure to find days between two dates

startdate = VALUE(DATEDIFF(MIN('Calendar'[Date]),MAX('Calendar'[Date]),DAY))

and im adding this measure into existing  measure 

Filter = 
var _seldate = VALUE(DATEDIFF(MIN('Calendar'[Date]),MAX('Calendar'[Date]),DAY))
Var _fitler =
SWITCH(
    TRUE(),
    SELECTEDVALUE(Incident[CreatedDate_1]) = BLANK(), 1,
    SELECTEDVALUE(CR[Schdule_Start_Date]) <= SELECTEDVALUE(Incident[CreatedDate_1]) &&
    SELECTEDVALUE(CR[Schdule_Start_Date]) >= (SELECTEDVALUE(Incident[CreatedDate_1])- _seldate), 1,
    0
)
return _fitler

its not working 

[CheenuSing]

Hi @itsranga ,

Can you share the data here as a csv or excel file.

Explain the data for table 2 and which columns should be filtered  based on selected value of created date in Table 1.

Cheers

CheenuSing

[itsranga]

@CheenuSing  

Click to Download  Sample Data 

if i click table 1 any row created date based i need to filter second table schedule start date 

example (if click first table first row means created date is 01/20/2025 ,  second table schedule date need to filter 01/20/2025 to 01/14/2025)  scheduled between 20th to 14th data required)

[v-zhangtin-msft · Accepted solution]

Hi, @itsranga 

I failed to open your link. I have simply modelled some data which I hope will solve your problem.

Measure = 
SWITCH(TRUE(),
SELECTEDVALUE(Table1[CreatedDate])=BLANK(),1,
SELECTEDVALUE(Table2[Schedule date])<=SELECTEDVALUE(Table1[CreatedDate])
  &&SELECTEDVALUE(Table2[Schedule date])>=SELECTEDVALUE(Table1[CreatedDate])-6,1,
0)

The two tables cannot be related. Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.