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

[pobilearner]

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

Module	Pass	Fail	Blocked
Module 1	20	5	1
Module 2	25	4	4
Module 3	15	6	2

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 

[v-chuncz-msft · Accepted solution]

@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