Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |