Forum Discussion
Selected 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.
Anonymous
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.