Forum Discussion
Solved
PowerBI - Exchange - Inbox Categories
Howdy, My company utilises Outlook Categories to manage tasks. Some emails end up with multiple categories, i.e. Category 1: what type of work it is?, 2. Staff Category: Who is working on it. W...
It looks like it repeats the email for each Category? Is there an ID field you can use to identify each email?
I've done a video on Survey data that has a similar (though not identical) dilemna in terms of needing to create Dimension tables and reconcile responses to questions where the respondent can select multiple items (similar to tagging the same email with multiple categories).
It might help: https://www.youtube.com/watch?v=UAjAtbN1MAY
Hmmm, good thinking. There is an ID field, will see what i can shake out of the tree with that.
Thanks for the suggestion. Good video as well. 🙂
Matt
AllisonKennedy
Community Champion
Community ChampionThanks! Keep us posted on how you get on and feel free @mention me in this or a new post if you're still struggling.