Skip to main content

 

I have a Date Type metric dimensioned by Project and Month. The “Project” Dimension has an Integer Property of “Relative Completion Day”. Number of Days can be positive or negative.

I am attempting to calculate a date based on adding “Relative Completion Day” property to the First Workday of the Next Month (M-F). Below is an Example of how it would Ideally Work.

What would be the best formula for this? I have also screenshotted my Day dimension.

 

Project Dimension:

 

Calculated Date: (2/3/2025 + (-3) = 1/29/2025) ; 2/3/2025 is the first workday of February - 3 workdays before that.

 

 

 

Day Dimension:

 

 

​@LAS This is the formula I used and the results it generated.
DayDDay.'Day of Week'.'Working Days'=true]uby firstnonblank:Day.Month]tselect:Month+1].'Start Date'+'16. 6dim] Project'.Relative_Completion_Day

  • The first part Day>Day.'Day of Week'.'Working Days'=true]rby firstnonblank:Day.Month]nselect:Month+1].'Start Date', is created for the first workday of next month. In the Day of week dimension, you can specify which day is workday.

Hey ​@Min Li Bright Point , this is almost perfect, but the only thing I am missing is that the “Relative_Completion_Day” is also meant to be in working days.

 

So in January as an example, it should offset 3 business Days back from the first business day of the next month (2/3/2023). So the 3 Business Days back from 2/3/2025 would be 1/ 29/2025.

 

Is that possible? Thanks so much for your help!

Reply


Ask your question here!

Terms & ConditionsCookie settings