Grouping Data in PowerBI Matrix based on a Month Bin Count

[dhawk]

I am attempting to recreate this table in PowerBI and cannot get the table to calculate data based on the bin grouping of a month.

I have the following constructed:

Row = Created On (where the error occurs) attempted to be New Group > Bin Size = 1 month
Columns = Source History (Chocolate, Vanilla, Swirl)
Value = Count of source history

It will tell me that date is not allowed as part of calculated column DAX expressions on DirectQuery models. I need to keep this data as a DirectQuery and cannot use the import option. I am curious if anyone has any recommendations on how to recreate this excel table inside of PowerBI. Followed along several different help articles but no luck. Thank you in advance to anyone who is able to make some recommendations.

[Chew_WenJie]

Hi, i think you can put two column (year & month) at Rows in matrix table, which it show every year and month.
Below image is the sample.

Matrix table: 

Hope this can help you.

[dhawk]

Thanks for your suggestion, this unfortunately didn't solve the issue.