Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Guys,
I have some data with date fields.
What I want to do is get the difference between these 2 days and group it under grouping table based on the number of days.
And the result should be how many orders are there for each group based on the number of days difference.
Answer should looks like this
Here is the file.
https://drive.google.com/file/d/1EY1GrBHieyd3XOpWvtWzGwiYqAmrkNfC/view?usp=sharing
Solved! Go to Solution.
This is the code I am Trying
Try this this should give the correct result.
Not giving the expected Answer.
Awesome 😀 Thanks a heap.
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |