Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Daily Mapping table

Hi Everyone,   I'm currently in a challenge with creating a daily mapping table , the scenario is :   I'm creating a employee daily snap shot for HR in Power BI, I have 1 fact table(exported dail...
Data Protection
Need Help
Show and Tell
hashtag_pete's avatar
hashtag_pete
Helper V
3 years ago

Hello, 

 

where do you get the department information from? In your first post, you say that you have the fact table automatically from a system, but based on what input do you know if Team 1 is working on a specific date for Department A or B?

BR

hashtag_pete

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi hashtag_pete , I maintain a Excel spreadsheet with the Team/Dep info and it is updated daily

    • hashtag_pete's avatar
      hashtag_pete
      Helper V
      3 years ago

      And this is your manual work?

      My point is: how can you systemwise know the department? If someone has to ask this and then manually enter it, you can't have an automatic solution. 

      If you get it from an system, you can solve the problem with a calculated table and summarizecolumns

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi hashtag_pete , I don't think where you get the mapping for team/dep(whether from system or a spreasheet) is important  in this question. 

         

        Any decision for structure changes is made by human, not systems. Once we know the changes we can either enter into the system, or a spreasheet, both manually. I don't think any tech can read a human's mind and automatically enter it into a system.