The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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