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