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 All,
My table 1 and Table 2 has (date with timestamp). i need to compare if the sales happen between particular period
eg table 1 = 01/01/2020 12:47(+3 or -3) need to compare in table 2 01/01/2020 12:44 and 01/01/2020 12:50
Solved! Go to Solution.
You want to compare and populate some value. What is the outcome of this comparison? Please explain with an example. Also share some data
You want to compare and populate some value. What is the outcome of this comparison? Please explain with an example. Also share some data
@amitchandak Thanks much in advance sir,
https://1drv.ms/u/s!ApPgrUdbr1NBbT4-UdfcQufC8Iw?e=SWehbd
if i select any col and walkin from line
my sales,transaction should split based on hour,day so on
as of now day is coming correct sales=140 and walkin=40 and transaction=52,but line should not be extended, hour wise how to do i dnt have any ideal. please please help
Need to use common timestamp table.
Yes its working now. Thanks for all your support
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 |
---|---|
90 | |
86 | |
85 | |
68 | |
49 |
User | Count |
---|---|
139 | |
112 | |
104 | |
64 | |
60 |