Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use parameter to add x weeks to a date.
02-09-2023
12:59 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-09-2023
01:34 PM
Try use SELECTEDVALUE instead of SUM. i.e
EstRecDate = SELECTEDVALUE(ChassisVins[Received Date]) + 'Weeks Selection'[Weeks Selection Value]*7
Helpful resources
Announcements
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Recommendations
Subject | Author | Posted | |
---|---|---|---|
05-21-2024 07:42 AM | |||
06-18-2024 07:19 AM | |||
07-07-2022 06:03 AM | |||
07-30-2022 05:03 AM | |||
07-02-2024 07:09 AM |
Featured Topics
Top Solution Authors (Last Month)
User | Count |
---|---|
96 | |
69 | |
43 | |
38 | |
29 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
154 | |
93 | |
63 | |
42 | |
41 |