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 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
Solved! Go to Solution.
While you can do that with row context is taken care. What is the output you want using that
As mentioned by you created timestamp table and joined with 2 facts table and formula is working
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
User | Count |
---|---|
134 | |
68 | |
68 | |
54 | |
52 |
User | Count |
---|---|
207 | |
95 | |
64 | |
61 | |
57 |