Forum Discussion

GopyMMJS's avatar
GopyMMJS
Frequent Visitor
4 years ago

Need an help with calendar table

Need Help with the calendar table

Hi Good Morning. I need assistance with one of the models which I'm working on now. It is an HR report. I have one calendar table connected to the main table, with the date of joining I calculated current employees and terminated employees. Now when I have leave data, when I take a date from the calendar table, it's showing the wrong values

The year from the fact table value is the correct one. If I select the year from the Calendar table it's showing the wrong value.

 

Please help me to solve this. I'm running short of time.

Need Help

3 Replies

  • nvprasad's avatar
    nvprasad
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi,

     

    Model looks fine, However if you are using inactive relationship for your calucaitons(measures), you need to use "USERELATIONSHIP" dax measure to trun inactive to active.

     

    Can you please check one of your measure which showing wrong result (if it is using inactive relationship) and try this.

     

    Appreciate a Kudos! ‌‌
    If this helps and resolves the issue, please mark it as a Solution! ‌‌

    Regards,
    N V Durga Prasad

    • GopyMMJS's avatar
      GopyMMJS
      Frequent Visitor
      4 years ago

      Can anyone have an answer for this?

  • GopyMMJS's avatar
    GopyMMJS
    Frequent Visitor
    4 years ago

    Hi Durga Prasad,

     

    That's not a problem. The inactive relationship is for the date of leaving and I used USERELATIONSHIP for calculating Leavers. Here the issue is If I use Year from the calendar table to see the no of leaves taken for the year, I'm getting an incorrect value