Forum Discussion
Date between two dates
Hi vpcontrol ,
I created a sample to implement it that may help you.
- Create a calendar table. And there is no relationships between the tables.
Table 2 = CALENDARAUTO()
- Create a measure.
Measure = var min_start = MIN('Table'[Start ]) var max_fin =MAX('Table'[Finish]) return IF( MAX('Table 2'[Date])>= min_start && MAX('Table 2'[Date]) <= max_fin, 1,0)I attached my sample that you can download and check if it is what you want.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
Thanks for you answer, but I need shows dates between two date (star and finish) for a events.
STAR DATE EVENT
03 October
FINISH DATE EVENT
06 October
I need to show in visual calendar, days between 03 October - 06 October, because days 3, 4 , 5 and 6 October is the period of celebration this event.
Thanks
Community SupportHi vpcontrol ,
I created a sample to implement it that may help you.
- Create a calendar table. And there is no relationships between the tables.
Table 2 = CALENDARAUTO()
- Create a measure.
Measure =
var min_start = MIN('Table'[Start ])
var max_fin =MAX('Table'[Finish])
return
IF( MAX('Table 2'[Date])>= min_start && MAX('Table 2'[Date]) <= max_fin, 1,0)
I attached my sample that you can download and check if it is what you want.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.