Forum Discussion

JKross's avatar
JKross
Icon for Helper I rankHelper I
1 year ago
Solved

Networkingdays per Employee based on their respective Working Model

Hi all,   I hope someone can help. I have to calculate the Networkingdays per employee based on their respective Working Model and the Bank Holidays. A Working Model defines which weekdays are the ...
  • johnt75's avatar
    johnt75
    1 year ago

    The Calendar table is fine as a location for the measure, it doesn't really matter which table you put it in.

    I would unpivot the working days table so that there are only 2 columns, Working Model ID and Working Day. There will be multiple rows for each Working Model ID but that is OK.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

Can you share a sample PBIX? You can share a link from Google Drive or OneDrive or similar

JKross's avatar
JKross
Icon for Helper I rankHelper I
1 year ago

Hi johnt75 I'd love to, but it is technically impossible unfortunately... I am following all steps and got seemingly blind... Let me see what I can extract. If you give me hints what you need I will take special care of it.

  • JKross's avatar
    JKross
    Icon for Helper I rankHelper I
    1 year ago

    Hi johnt75  - strangest thing of all: I extracted some data and set up a sample PBIX, and there the calculation works out perfectly! I think I have to follow the steps with the real data myself... Thank you for the hint...