- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
user story and task rollups
Not sure if this is the right forum, but here is the issue: I am tryin to create a sioimple report which shows all client costs (charges) to date. I am using one view table from TFS_Warehouse (on-prem TFS) and anotehr table which has the resource info (name, rate, etc.). I have created a measure which calculates the cost based on the rate and completed work at task level. Now I need to show the rollups to the uer story level where the client is tagged. Is there a way to use DAX, or another means, to associate the user stories with the child tasks so I can make that calculation? Any help would be appreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @spsalter,
Yeah, you are in the right place. But we can't write out a dax formula without data model. Can you please provide a sample .pbix file?
Best Regards!
Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
what is the best way to send over pbix? Seems I can only upoad photo files.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @spsalter,
If you can send it publicly, you can upload your file into GoogleDrive, OneDrive, etc. then share the link here. Or send me the link by private message.
Best Regards!
Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@v-jiascu-msft, let's give this a shot: https://1drv.ms/u/s!AkgfL6evUx7Jebx0NKgun4atOBI It's the template to reduce the file size. If data is needed, I can cleanse it and upload. Much appreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @spsalter,
I can't open this link, Can you update it?
Best Regards!
Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I will try to share it out form a different source - https://drive.google.com/file/d/0B1yTINZv_mcEQmkyMGpOX1U5WHM/view?usp=sharing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @spsalter,
1. I created a new date table.
Calendar = CALENDAR ( DATE ( 2016, 1, 1 ), DATE ( 2019, 12, 31 ) )
2. A new column of table CurrentWorkItemView.
RelationshipDate = [System_CreatedDate].[date]
3. Establish relationship through CurrentWorkItemView[RelationshipDate] and Calendar[Date].
Could you please make more clear about "child tasks", "the client is tagged", "user story"? Because I can't find it in the model.
You can check it out in your private message.
Best Regards!
Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
09-29-2024 08:37 PM | |||
Anonymous
| 07-07-2022 12:25 AM | ||
04-29-2024 04:19 AM | |||
Anonymous
| 08-03-2022 07:36 AM | ||
Anonymous
| 11-21-2024 04:56 PM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |