Forum Discussion

gclements's avatar
gclements
Helper II
5 years ago
Solved

Calculate dates between

Hi,  I have the below measure which calculates the number of days between two dates filtered by the datebetween function.  I only want to show this measure when it falls between the dates provided in...
Need Help
  • gclements's avatar
    gclements
    5 years ago

    Thansk for the reply but I fixed this by adding a FILTER instead of the DATESBETWEEN:

    CALCULATE (
    DATEDIFF ( MAX ( Charge[Charge Date 1] ), [Current Rental To Date], DAY ),
    FILTER(Charge, Charge[Charge Date 1] >= [Current Rental From Date])
    )
gclements's avatar
gclements
Helper II
5 years ago

Thansk for the reply but I fixed this by adding a FILTER instead of the DATESBETWEEN:

CALCULATE (
DATEDIFF ( MAX ( Charge[Charge Date 1] ), [Current Rental To Date], DAY ),
FILTER(Charge, Charge[Charge Date 1] >= [Current Rental From Date])
)