Forum Discussion

vpcontrol's avatar
vpcontrol
Regular Visitor
6 years ago
Solved

Date between two dates

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

 

 

 

 

 

 

 

 

Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    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.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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/42251

     

    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's avatar
      vpcontrol
      Regular Visitor
      6 years ago

      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's avatar
        v-xuding-msft
        Community Support
        6 years ago

        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.