Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Try use SELECTEDVALUE instead of SUM. i.e
EstRecDate = SELECTEDVALUE(ChassisVins[Received Date]) + 'Weeks Selection'[Weeks Selection Value]*7
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |