Forum Discussion

itsranga's avatar
itsranga
Helper I
1 year ago
Solved

Selected Value based Last 7 days value required

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

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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's avatar
      itsranga
      Helper I
      1 year ago

      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)

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        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.

  • itsranga's avatar
    itsranga
    Helper I
    1 year ago

     Anonymous   

    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