Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
87 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
122 | |
109 | |
60 | |
55 |