Forum Discussion
need help on creating a Power BI report
Hi All, i am new to Power BI and i am trying to create this report for more than 5 days buti am not able to do it, please help me.
I have the following tables in Power BI:
- projects_data
- workitems_data
- worktimes_data
- sprints_data
- ai_time_history
I need to build a report with these filters:
- projects_data.projectCategory
- Month(can take from any table but should filter all the tables and charts)
- sprints_data.name
And a Table visual that should display these columns:
- workitems_data.issueKey
- workitems_data.issueSummary
- workitems_data.issueType
- workitems_dataissueRunningStatus (Status)
- projects_data.projectName
- workitems_data.Sprint Name
- worktimes_dat.totaltimehrs
Additionally, I need two calculated fields:
1. AI Dev Hrs Saved
2. AI Testing Hrs Saved
Logic for both:
- Each issueId has multiple records in ai_time_history
- The field column contains two relevant values:
- "AI Dev Hrs Saved"
- "AI Testing Hrs Saved"
- For each issueId, find records for the respective field
- Use changedAt to identify the latest record
- Return the corresponding latest changedTo value
Example:
| 101 | AI Dev Hrs Saved | 2 | Jan |
| 101 | AI Dev Hrs Saved | 5 | Feb |
| 101 | AI Dev Hrs Saved | 8 | Mar |
Expected output for issue 101:
AI Dev Hrs Saved = 8
Same logic applies for AI Testing Hrs Saved.
Please suggest:
- Correct data model relationships
- DAX/calculated table/measures needed
- Best approach to ensure slicers filter everything correctly
For your reference.
There are four relationships below.
'projects_data'[projectId] 1----* 'workitems_data'[issueProjectId]
'projects_data'[projectId] 1----* 'sprints_data'[projectId]
'projects_data'[projectId] 1----* 'worktimes_data'[issueId]
'projects_data'[projectId] 1----* 'at_time_history'[issueId] <-- There were no matching IDs in those two data tables."
4 Replies
- rajendraongole1
Super User
Hi Muzammil_Abdul - Since you're new to Power BI, I’d strongly recommend starting with the basics before jumping into full report logic.
First, try the following steps yourself:
1. Import all the tables into Power BI.
2. Build the data model by creating relationships between:
workitems_data (central table)
projects_data
sprints_data
worktimes_data
ai_time_history
Ensure you understand how filters flow between tables (this is key for slicers to work).
Once you have the model ready, then move to creating measures.
I hope below links helps you to learn moe about relationships and so on.
https://learn.microsoft.com/power-bi/transform-model/desktop-relationships-understand
https://learn.microsoft.com/power-bi/guidance/star-schema
https://learn.microsoft.com/power-bi/transform-model/desktop-quickstart-learn-dax-basics
Power BI Complete Course 2026 - Beginner to Expert in 20 Hours (Free Tutorial)
After you’ve built the model, feel free to share your issue like relationships or DAX errors, and the community can help more effectively.
- danextian
This looks less like a single Power BI question and more like an end-to-end consulting engagement. Community forums are generally “best effort” support and work best for focused, specific questions (for example, troubleshooting one relationship issue or validating one DAX measure), rather than designing an end-to-end solution from scratch. This likely needs hands-on consultation more than forum responses can realistically provide.
- mickey64
For your reference.
There are four relationships below.
'projects_data'[projectId] 1----* 'workitems_data'[issueProjectId]
'projects_data'[projectId] 1----* 'sprints_data'[projectId]
'projects_data'[projectId] 1----* 'worktimes_data'[issueId]
'projects_data'[projectId] 1----* 'at_time_history'[issueId] <-- There were no matching IDs in those two data tables."
Thank you mickey64
