Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
My english too bad for this hope you can understand. I have problem like some guide comes 10 time in year to my store and i need to find how much days to take between that 10 comes?
Solved! Go to Solution.
not sure if this is what you want
Proud to be a Super User!
Hi @Dk_bbr
Give sample data of your model so we can provide you the solution.
How many columns are there in your report?
could you pls provide some sample data and expected output?
Proud to be a Super User!
Date | GuideID | GuideName | ComesIn | Sales |
1/1/23 | 10051 | Bam | 1 | 5000 |
2/1/23 | 10051 | Bam | 1 | 15022 |
3/14/23 | 10051 | Bam | 1 | 151563 |
5/24/23 | 10051 | Bam | 1 | 15400 |
5/30/23 | 10051 | Bam | 1 | 3600 |
6/15/23 | 10051 | Bam | 1 | 9500 |
7/23/23 | 10051 | Bam | 1 | 4500 |
8/1/23 | 10051 | Bam | 1 | 3250 |
8/15/23 | 10051 | Bam | 1 | 8900 |
That ComesIn only equils to 1 and i want to know average interval days in these between 10 dates? is that possible like similar to in year 10 times and in a month 2 times?
not sure if this is what you want
Proud to be a Super User!
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |