Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
gclements
Helper II
Helper II

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 DateBetween.  This works until I add the +1, then it provides a value against all dates (see image).  How do I add 1 without breaking the filter?

 

    MEASURE Charge[RentalDaysUsed] =
        CALCULATE (
            DATEDIFF ( [CurrentRentalFromDate], MAX ( Charge[dtChargeDate1] ), DAY ) + 1,
            DATESBETWEEN (
                Charge[dtChargeDate1],
                [CurrentRentalFromDate],
                MAX ( Charge[dtChargeDate1] )
            )
        )

Untitled.png

1 ACCEPTED SOLUTION
gclements
Helper II
Helper II

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])
)

View solution in original post

2 REPLIES 2
gclements
Helper II
Helper II

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])
)
BA_Pete
Super User
Super User

Hi @gclements ,

 

You could try something like this:

Charge[RentalDaysUsed] =
VAR __daysUsed =
CALCULATE(
  DATEDIFF(
    [CurrentRentalFromDate],
    MAX(Charge[dtChargeDate1]),
    DAY
  ),
  DATESBETWEEN(
    Charge[dtChargeDate1],
    [CurrentRentalFromDate],
    MAX(Charge[dtChargeDate1])
  )
)
RETURN
SWITCH(
  TRUE(),
  ISBLANK(__daysUsed), BLANK(),
  __daysUsed + 1
)

 

Not the most elegant solution, but should get you over the line.

 

Pete 



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors