Forum Discussion
natabird3
Skilled Sharer
7 years agoQuestion on YoY in a table with multiple sub categories
Hello,
If i have the following sample data set:
In comments due to unable to post here.
Is it possible to create the same table as the one from my screenshot below in Power Bi? Measuring YoY change and average number of comments per post type - organic, organic + paid and paid (so far this part i can make, however where i am stuck is on how do i do YoY when we have multiple filtering)? Does Power Bi have the functionality to do that?
Please let me know, thanks.
Regards,
Jordan
4 Replies
- natabird3
Skilled Sharer
O/O+P/P Country Date Content Type Comment Count Paid Italy 42985 photo 178 Organic + Paid Italy 43578 photo 559 Paid Italy 42985 photo 404 Organic + Paid Italy 43175 link 13 Paid Italy 42985 photo 349 Paid Italy 42985 photo 99 Paid Italy 43581 photo 0 Paid Italy 43581 photo 0 Organic + Paid Italy 43581 photo 0 Organic Italy 43092 photo 5045 - v-frfei-msft
Community Support