Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need assistance, I am new to PowerBI and especially DAX. I am trying to write a bug arrival report that includes days with 0 bugs written and days where there is a record in my source VSTS data. I was able to use PowerBI to create a report, but it did not include days where there were no bugs entered because those records did not exist in the source data. I am trying to create another table to use in my graphing.
VSTS Source Data
Below is a Table I created with Columns: Date, Period and CreatedDate.
I want the values in CreatedDate in the DatePeriod table to equal the number of instances found in the CreatedDate column from VSTS. Currently my code is bringing back the total number of records in the VSTS table and populates each row in the CreatedDate column regardless of bugs written on a particular day. It does not seem like it should be rocket science to do this, but I am hitting a brick wall and have run out of ways to search google for where this has been solved elsewhere. Any help would be greatly appreciated.
Solved! Go to Solution.
Hi @pchilton
If you add the following calculated column to your 'Date' table, it will return a count or child rows from the 'WorkItemsView' table, so long as you have a relationship between the two tables
Created Date = COUNTROWS(RELATEDTABLE('WorkItemsView'))
Hi @pchilton
If you add the following calculated column to your 'Date' table, it will return a count or child rows from the 'WorkItemsView' table, so long as you have a relationship between the two tables
Created Date = COUNTROWS(RELATEDTABLE('WorkItemsView'))
Well, that was easy. Thank you very much!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |