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 September 15. Request your voucher.

Reply
picoz
New Member

Use parameter to add x weeks to a date.

I am trying to figure out how to use a parameter to add x weeks days to a date field per row and show the result in that row.  I created a parameter for the selection called Weeks Selection.  It has between 10-20 in it.  Then I have a table A with the "Recieved Date" where I am would like to create a measure that will add the "Weeks Selection Value" to "Recieved Date" for each row in table A.  Then I want to show this along with all the other values I have in a Table visual.

 

EstRecDate = SUM(ChassisVins[Received Date]) + 'Weeks Selection'[Weeks Selection Value]*7
 
I am not sure what this is doing but when I check the box to add EstRecDate to my table visual it takes forever to run and isn't doing what I expect it to.  It seems that most of my table visual is blank and only the EstRecDate is filled with 1/11/1900... 

 

1 REPLY 1
vicky_
Super User
Super User

vicky__1-1675978420721.png

 

Try use SELECTEDVALUE instead of SUM. i.e 

EstRecDate = SELECTEDVALUE(ChassisVins[Received Date]) + 'Weeks Selection'[Weeks Selection Value]*7

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Kudoed Authors