cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Blake753
Helper II
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

var Fdate = Ldate - 14

View solution in original post

5 REPLIES 5
daxer-almighty
Solution Sage
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.

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

var Fdate = Ldate - 14

View solution in original post

@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?

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.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors