Forum Discussion
PowerBI - Exchange - Inbox Categories
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
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
Thanks! Keep us posted on how you get on and feel free @mention me in this or a new post if you're still struggling.