linking both facts based on date condition

[Anonymous]

Hi Experts,

i have two facts and a date table, all three are date with timestamp. 

Datetable(timestamp) M:1 Custfacts (timestamp) - relationship is active

Datetable(timestamp) M:1 Salesfacts(timestamp) - relationship is Inactive active

now i need to join Custfacts (timestamp) with Salesfacts(timestamp), for that i need join  Salesfacts(timestamp)   +3 or -3 datetime

eg:Custfacts (timestamp) 01/01/2020 12:47 =  Salesfacts(timestamp) 1 01/01/2020 12:45 and 01/01/2020 12:48

how can i do that please help

[amitchandak · Accepted solution]

While you can do that with row context is taken care. What is the output you want using that

[Anonymous]

As mentioned by you created timestamp table and joined with 2 facts table and formula is working

[Anonymous]

Sir,

My line chart is no of customer id and bar chart is sales value based on hour

from date table/ hour column = 10 ,12 ,14, 16

line chart is no of customer id= 19,22,38,33

bar chart 0.5k, 0.4k,0.3k