Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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.
@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
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
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.
User | Count |
---|---|
128 | |
73 | |
70 | |
58 | |
53 |
User | Count |
---|---|
193 | |
96 | |
66 | |
62 | |
52 |