The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello all,
I'm new to Power BI Desktop, so please excuse the naiveté.
I am looking to create a Matrix visual from a dynamically fed (Dataverse report) table that will have dates running from the start of a project to the end of a project, each project can have multiple deliverables. The deliverables have a date in a plan deliverable start column and a date in a plan deliverable end column, the plan is to allocate hours for each week throughout a project in a 3rd column. The Matrix is intended to show how the hour's allocation is broken out by day and can be drilled to a month and year view, the start date and end date should only include weekdays. Please see examples:
Solved! Go to Solution.
@BatmanRobin , Try if this approach can help
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
@BatmanRobin , Try if this approach can help
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
User | Count |
---|---|
77 | |
75 | |
36 | |
31 | |
29 |
User | Count |
---|---|
94 | |
80 | |
55 | |
48 | |
48 |