Forum Discussion
How to add custom date differnce filed in report.
Anonymous I'm assuming you are using the VSTS content pack... If that is the case, unfortunately there is currently no way to add any additional objects to the model in the Service...
Hi Anonymous,
By using the VSTS content pack in Power BI Service, we are not able to add new field or compare two date columns.
Based on my research, one possible method is to create custom queries over the VSTS REST API, get work item data in Power BI Desktop , then you are able to add new calculated fields, format the values and create reports within the VSTS data source in Desktop. For more details, please review the following blog.
https://blogs.endjin.com/2016/07/querying-the-vsts-work-items-api-directly-from-power-bi/
Thanks,
Lydia Zhang
Hi Anonymous,
By using the VSTS content pack in Power BI Service, we are not able to add new field or compare two date columns.
Based on my research, one possible method is to create custom queries over the VSTS REST API, get work item data in Power BI Desktop , then you are able to add new calculated fields, format the values and create reports within the VSTS data source in Desktop. For more details, please review the following blog.
https://blogs.endjin.com/2016/07/querying-the-vsts-work-items-api-directly-from-power-bi/
Thanks,
Lydia Zhang
Thanks Anonymous Anonymous for responce. Now I have answer.