Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
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.
Thanks for your suggestion, this unfortunately didn't solve the issue.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
39 | |
24 | |
21 | |
21 | |
13 |