Forum Discussion

Sujit_Thakur's avatar
Sujit_Thakur
Solution Sage
6 years ago
Solved

date time Relationship

Dear all, I have two tables Table A and Table B    Table A is a event where for every day we store records for every event along with time for eg    date column.   Time column  8/11/2020       ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Sujit_Thakur,

    It is impossible to build relationships as same as your requirement.

    In my opinion, I'd like to suggest you write a measure formula to check records based on your selections and use on 'visual level filter' to filter records.

    You can create two slicers that no direct effect the visual to pick up selected values of date values and time range.

    Measure =
VAR selectedDate =
    MAX ( Calendar[Date] )
VAR timeRange =
    ALLSELECTED ( Selecotr[Hour] )
VAR currDate =
    MAX ( Table[Date] )
VAR currTime =
    MAX ( Table[Time] )
RETURN
    IF (
        curDate = selectedDate
            && AND (
                HOUR ( currTime ) >= MINX ( timeRange, [Hour] ),
                HOUR ( currTime ) <= MAXX ( timeRange, [Hour] )
            ),
        "Y",
        "N"
    )

    Reference link:

    Applying a measure filter in Power BI 

    Regards,

    Xiaoxin Sheng

Sujit_Thakur's avatar
Sujit_Thakur
Solution Sage
6 years ago

Dear amitchandak sir ,

Yes this example video was very relevant 

Thanks for that 

 

But my problem has To and from time in Table B where I have to relate Table A and Table B in such a way that To time and from time column gets related with Time stamp of Table A 

 

Is that even possible ??

Please help 

 

Regards 

Sujit