Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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
what is the best way to send over pbix? Seems I can only upoad photo files.
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
@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.
Hi @spsalter,
I can't open this link, Can you update it?
Best Regards!
Dale
I will try to share it out form a different source - https://drive.google.com/file/d/0B1yTINZv_mcEQmkyMGpOX1U5WHM/view?usp=sharing
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |