I have calculate the First Workday on the Day Dimension and want to look up that date on the Month dimension. How can I lookup the First Workday on the Day dimension from the Month dimension. Screenshots below:
+12- Employee
Hi,
You can do:
IF(ISDEFINED(Day.First_Workday),Day)[by firstnonblank: Day.Month]
First part is checking if it is the first workday of the month and if yes, getting the day item. Then aggregates to the Month, which brings the day value to the month dimension
+12- Employee
- Answer
your property should be of type Day, not Date
if you want the date, then formula is even simpler:
Day.First_Workday[by firstnonblank: Day.Month]
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.