Forum Discussion

dhawk's avatar
dhawk
New Member
4 years ago

Grouping Data in PowerBI Matrix based on a Month Bin Count

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.

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • Chew_WenJie's avatar
    Chew_WenJie
    Icon for Resolver III rankResolver III
    4 years ago

    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's avatar
      dhawk
      New Member
      4 years ago

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