cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pobilearner Frequent Visitor
Frequent Visitor

How to create monthly trend to track the change in a sum of values of a test

I am pulling the latest execution stats from the DB for the tests being executed via automation in the below format

ModulePassFailBlocked
Module 12051
Module 22544
Module 31562

 

Since my query always fetches the latest exeuction status, I want to know if there is a way in Power BI which allows me to track monthly/daily trend of sum of failures i.e in Nov, the failures count was 15 and Dec it came down to 10. This would help me track the progress made in fixing issues and bringing them down to 0. Please help 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to create monthly trend to track the change in a sum of values of a test

@pobilearner,

 

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/Store-the-daily-live-date-into-a-table/td-p/482302

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: How to create monthly trend to track the change in a sum of values of a test

@pobilearner,

 

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/Store-the-daily-live-date-into-a-table/td-p/482302

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.