Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Using datesbetween

Hello! I Have the following problem, I have 3 columns: My initial Date, Final Date, and production between the dates, like the folowwing example: Initial Date Finish Date Production 0...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous

     

    You may add a column for the sample table:

    Days = DATEDIFF(Table[Initial Date],Table[Finish Date],DAY)

    Then you may get the measure and show all the dates included.

    Divide =
CALCULATE (
    DIVIDE ( MAX ( Table[Production] ), MAX ( Table[Days] ) ),
    FILTER (
        GENERATE ( 'Calendar', Table ),
        'Calendar'[Date] >= Table[Initial Date]
            && 'Calendar'[Date] <= Table[Finish Date]
    )
)

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous

 

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.

 

Regards,

Cherie

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    It worked!
    The only thing I changed was instead of using MAX, i Used SUM.