Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
itsranga
Frequent Visitor

Selected Value based Last 7 days value required

Hi,

 

  I have a 3 table

1. Table1

2. Table2

3. Calender

Relationship  

 

relationship.png

 

 

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

 

Actual Data:

actual data.png

 

 

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

result_3.png

 

 

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

1 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)

vzhangtinmsft_0-1737530656015.png

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.

View solution in original post

4 REPLIES 4
itsranga
Frequent Visitor

 @v-zhangtin-msft   

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

itsranga_0-1738058241238.png

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
Community Champion
Community Champion

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

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

@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)

 

actual data.png

 

 

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)

vzhangtinmsft_0-1737530656015.png

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.