Obtaining date range

[Syndicate_Admin]

Good morning, I have two date filters where in one the Fecha_inicio is selected and in another the Fecha_fin, coming from two different Date tables (Dates and Dates1). I want to get the date range in a column, in which all the days included in this case between 05/12/2020 and 10/12/2020 appear. These are the filters I have:

And here's what I want to get:

Thank you very much and greetings!

[v-zhangti · Accepted solution]

Hi @Syndicate_Admin ,

You can try the following methods. Let me give you an example of creating a new table that includes Date1 and Date2.

Table:

Table = CALENDAR(MIN(Date1[Date1]),MAX(Date2[Date2]))

Create another Measure to filter the display date of this table.

Measure =
IF (
    SELECTEDVALUE ( Date1[Date1] ) <= SELECTEDVALUE ( Date2[Date2] ),
    IF (
        SELECTEDVALUE ( 'Table'[Date] ) >= SELECTEDVALUE ( Date1[Date1] )
            && SELECTEDVALUE ( 'Table'[Date] ) <= SELECTEDVALUE ( Date2[Date2] ),
        1,
        0
    ),
    IF (
        SELECTEDVALUE ( 'Table'[Date] ) <= SELECTEDVALUE ( Date1[Date1] )
            && SELECTEDVALUE ( 'Table'[Date] ) >= SELECTEDVALUE ( Date2[Date2] ),
        1,
        0
    )
)

Put Measure in the filter and set it equal to 1.

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

Good morning, This helped me solve my problem with the date range, the only thing that when trying to show values in that table, it repeats the same value for all days, instead of showing me the corresponding, attached photo. I do not know if it is due to a topic of relationships between the tables or what the problem may be:

Thanks a lot

Greetings.

[Tahreem24]

@Syndicate_Admin  Create a date table like below:

Date Table = CALENDAR(MIN(Fecha_inicio),MAX(Fecha_fin))

[Syndicate_Admin]

Good I have intended what you tell me and creates a column the last value of the column Fecha_fin.

[Tahreem24]

@Syndicate_Admin Only take MIN and MAX. Remove X from both functions.