Forum Discussion
Helper ISelected Value based Last 7 days value required
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.
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
Helper IAnonymous
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)
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.