Date between two dates

[vpcontrol]

Hello everyone,

I have a problem with a calendar. I need help.

I have a table with two dates. 

First date

02/01/2019

Last date

02/03/2019

I want to draw days between DATE INICIO and DATE FIN in a visual calendar. In this moment visual calendar only show DATE INICIO. 

I need a visual calendar with days 3, 4 , 5 y 6 drawn. Is it possible with dax?

Thanks

[amitchandak]

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.

https://community.powerbi.com/t5/Desktop/DATE-RANGE-SLICERS-TO-COMPARE-NETSALES-OF-A-DATE-RANGE/td-p...

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.

[vpcontrol]

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

[v-xuding-msft · Accepted solution]

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.