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
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.