Forum Discussion
Ideas for Dynamic Product Release Date
Power Users:
Would like some ideas on how to dynamically change Day 1-180, Week 1-45 based on product release date.
For example:
Dashboard is created that is filtered by Product.
Tables and Metrics on Dashboard are filtered on Product Release Date.
Example:
User selects Product 1 on Dashboard and lookup table brings back a release date value of 2/15/22. Thus,
Day 1 = 2/14/22, Day 2 = 2/15/22, Day 3 = 2/16/22...etc...
Week 1 End Date = 2/20/22, Week 2 End Date = 2/27/22...etc
Tables and graphs pick up Daily and Weekly values as Day 1, Day 2,...or Week 1, Week 2...
Then, user select different Product from Dropdown - Product 2 and lookup table brings back a release date of 1/10/22
Day 1 = 1/10/22, Day 2 = 1/11/22...etc. Week 1 End Date = 1/16/22...etc...
How to dynamically refresh the product release date so that Day 1-180 and Week 1-45 change according to Product?
Your expertise and help are more than appreciated.
6 Replies
- lbendlin
Super User
"User selects Product 1 on Dashboard" that's not how dashboards work. Did you mean to say report ?
How does the user select that product? Is that process identifiable via SELECTEDVALUE() ? Does the product column come from a disconnected table or is the table wired into your data model?
Hopefully this makes it more clear.
User filter selects product say from a dropdown; causes date to change to a new release date for that product, calendar table then updates dynamically and marks dates as below so that calculations can be made based on day and week numbers without reference to specific calendar dates. Basically need calendar table dates from for example 2/11/20 - 4/1/20 to be marked with days / week numbers accordingly afer product is selected from a slicer/dropdown menu. Core reporting stays the same but populates with values and metrics for different product.
Product 1 Prouct 2 Date Day # Week # Date Day # Week # 2/11/20 1 1 3/10/20
1 1 2/12/20 2 1 3/11/20 2 1 2/13/20 3 1 3/12/20 3 1 2/14/20 4 1 3/13/20 4 1 2/15/20 5 1 3/14/20 5 1 2/16/20 6 1 3/15/20 6 2 2/17/20 7 2 3/16/20 7 2 2/18/20 8 2 3/17/20 8 2 2/19/20 9 2 3/18/20 9 2 2/20/20 10 2 3/19/20 10 2 2/21/20 11 2 3/20/20 11 2 - lbendlin
Sorry, not clear. Where is the release date? What are you measuring?
Apologies...yes...Report, not Dashboard.
SELECTEDVALUE() does work.
Product and Product release date are in a Product Table. Selecting title and date is no problem.
The problem arises when you select a second product from Product list. The second product's, Product 2's, release date is different from Product 1. So, calculated weekly columns / daily columns no longer apply.
Is there a way to dynamcially change the definitions of week 1, week 2, etc...based on different release dates.
Thanks again.
Is there a way to dynamically
- lbendlin
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
