Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
jabbajuice08
Frequent Visitor

Add Duration to a Date in a Measure to Get New Date

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. 

1 REPLY 1
yyzheng12
Helper I
Helper I

I would try to use Switch and Selectedvalue dax functions: 

 

dynamic_selection_measure = switch(true(), selected(columnName) = value, action_measure_1, ...)

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.