cancel
Showing results for
Did you mean:
Helper II

## EDATE for days or weeks

I am recycling a function that works perfectly minus the EDATE function.  I am looking for the same thing as EDATE but I need it to operate as days or weeks (whichever one is easier) as opposed to months.  Is there a simple solution for this?  Here's my code for reference:

Prod Metric 2 = var Ldate = DATE(YEAR(MAX('Date Slicer'[Pay Period])), MONTH(MAX('Date Slicer'[Pay Period])), DAY(max('Date Slicer'[Pay Period])))
var Fdate = EDATE(Ldate,-6)
var sumUCC = [Productivity]
RETURN
IF(min(Dates[Date_Id])<Fdate, blank(), IF(min(Dates[Date_Id])>Ldate,blank(),sumUCC))

1 ACCEPTED SOLUTION
Solution Sage
``var Fdate = Ldate - 14``
5 REPLIES 5
Solution Sage
IF you have a date and you add integers (positive and negative) to it, the addition will return the day that many days after or before the date.
Helper II

@daxer-almighty could you put that solution into my code?  Let's say I want to return 2 weeks or 14 days.

Solution Sage
``var Fdate = Ldate - 14``
Helper II

@daxer-almighty Thank you that seems to work perfectly.  I do have a quick follow up question:  This works in a matrix format but I am trying to disply this info in a KPI visual as well.  The KPI visual is coming up blank, do you have any suggestions?

Solution Sage
Well, you should analyze your measure that you use in your visuals. The answer to your question is hidden in the logic of the measure. When you're dropping a measure onto a KPI visual, you should be aware of what data is visible to the formula. In other words, which data is filtered out and which data stays. If you understand this, you'll know why your formulas return what they return.

Announcements