how to find interval between dates

[Dk_bbr]

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?

[Uzi2019]

Hi @Dk_bbr 

Give sample data of your model so we can provide you the solution.
How many columns are there in your report?

[ryan_mayu]

could you pls provide some sample data and expected output?

[Dk_bbr]

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?

[ryan_mayu · Accepted solution]

not sure if this is what you want

Column =

VAR _last=maxx(FILTER('Table','Table'[GuideID]=EARLIER('Table'[GuideID])&&'Table'[Date]<EARLIER('Table'[Date])),'Table'[Date])

return if(ISBLANK(_last),blank(),DATEDIFF(_last,'Table'[Date],DAY))

then create a measure

measure = AVERAGE('Table'[Column])

pls see the attachment below