Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Obtaining date range

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:

Alberto99_0-1648197901263.png

And here's what I want to get:

Alberto99_1-1648197933014.png

Thank you very much and greetings!

  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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.

5 Replies

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    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's avatar
      Syndicate_Admin
      Administrator
      4 years ago

      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.