Forum Discussion

skasper's avatar
skasper
Responsive Resident
9 years ago
Solved

Not the usual Working Day Problem

First, I searched and tested the variou solutions for calculating working days in this community and others. None of those applies to my situation as far as I could see.   Here is the situation: ...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    Hi skasper,

     

    As I said and based on your explanation the question is that you need to make you DimDate[date] as x-axis in your visuals to achieve the hierarchy and the correct values in your measures not the Effort Date since you have a relationship (that I assume is 1-Many) the visuals will be ok.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
9 years ago

Hi skasper,

 

As I said and based on your explanation the question is that you need to make you DimDate[date] as x-axis in your visuals to achieve the hierarchy and the correct values in your measures not the Effort Date since you have a relationship (that I assume is 1-Many) the visuals will be ok.

 

Regards,

MFelix

skasper's avatar
skasper
Responsive Resident
9 years ago

Frankly, I am not sure why I never thought of tackling it from that direction. I was just completely stuck on the Effort Date from the WorkLog.

 

Suffice to say, this works perfectly and you are my personal Hero of the Day.

 

Thank you for the fast and competent advice.

 

Sascha