Question on YoY in a table with multiple sub categories

[natabird3]

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

[natabird3]

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]

Hi @natabird3 ,

How to convert your date column to date format?

[natabird3]

@v-frfei-msft apologies, it was supposed to be the usual date format day/month/year like in excel.            

[natabird3]

O/O+P/P	Country	Date	Content Type	Comment Count
Paid	Italy	9/7/2017	photo	178
Organic + Paid	Italy	4/23/2019	photo	559
Paid	Italy	9/7/2017	photo	404
Organic + Paid	Italy	3/16/2018	link	13
Paid	Italy	9/7/2017	photo	349
Paid	Italy	9/7/2017	photo	99
Paid	Italy	4/26/2019	photo	0
Paid	Italy	4/26/2019	photo	0
Organic + Paid	Italy	4/26/2019	photo	0
Organic	Italy	12/23/2017	photo	5045