Grouping Data in PowerBI Matrix based on a Month Bin Count

Question

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.

Answer 1

Hi @D Hawk

Unfortunately Power BI is not supported on this forum at this time. It is best that you reach out to PowerBI experts at https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services and they will gladly assist with more expertise.

----------------------------------------------

If this is helpful please accept answer.