Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
So I'm basically just trying to use a parameter that the user can select (1, 1.5, 2) to multiply by my Rem_Dur column and then add that new duration number to a start date column.
For example, If the user selects 1.5, and one of the tasks has a Rem_Dur of 10, the new duration is 15. That task has a start date of 2/1/2023 so the new date that would be displayed in my measure would be 2/16/2023. I know I cannot use a calculated column since I need the date to be dynamic, but not sure what syntax to use.
I would try to use Switch and Selectedvalue dax functions:
dynamic_selection_measure = switch(true(), selected(columnName) = value, action_measure_1, ...)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |