Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I used this post to expand recurring events into my Power BI model - https://community.fabric.microsoft.com/t5/Desktop/Transforming-Exchange-server-data-with-recurring-a...
So I have them all listed, however the indivudual responses all default to the original recurring instance/master. If I marked 'tentative' on the first occurence, that shows for all occurences, regardless of the ones that were marked as 'accepted' or declined'. I'm needing to show a report on the # of these recurring meetings that were attended, so I need to get to the individual responses.
Any ideas?
Thanks in advance.
Any ideas? I'm running into dead ends along recurring meetings everywhere I look.
I followed the query from the link in my OP to expand out the recurring meetings. When it expands, it shows all the single occurances as 'tentative'. I responded tentative to the whole series and then respond 'accept' to the individual occurance that I attend.
Below is the sshot of the Feb 26th meeting accepted on my outlook.
In Power BI, it doesn't reflect this. It shows the response to the first occurance of the series which is 'tentative'.
I'm looking for a way to have Power BI show the instances of a recurring meetings acceptance accurately.
Thanks!
Please post some sample data.
Show what you have (A) and show what you want to get (B) . Explain the logic to get from A to B.
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
62 |