I am trying to create a line graph in Power BI to show the difference between a number of opened tickets vs resolved tickets on a daily basis. I then want to show a line graph of the cumulative data. I am new to Power BI and whilst I can easily achieve this in Excel, I cannot get what I need. The data is shown below from Excel. The Balance is the difference between Opened and Resolved and then each day it either increases or decreased based on this difference. DateOpenedResolvedBalance18/04/201652351719/04/201662473220/04/2016111915221/04/20161301037922/04/20161419612423/04/20166013024/04/20168113725/04/20161088016526/04/20161018817827/04/2016737118028/04/2016695519429/04/20169310018730/04/20164019101/05/20162019302/05/20163119503/05/2016859718304/05/2016689815305/05/2016607513806/05/2016738013107/05/201630134 The raw data I have is as below, where the Incident Number is a unique reference

andrew_hardwick Couple small changes since there are blank dates... But you should be set now! Let me know.

Cumulative backlog to date | Microsoft Fabric Community