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.
I am not sure I got it completely. But please try.
You can join date dimension with both the dates and use them is the formula as per need using use relation.
This is not exact example but very similar.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
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
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.
