Calculating Completion Percent Based on Multiple Date Fields

Hi jwesle 

You can create columns to meet your demand.

Total Open Lines = CALCULATE(SUM(Table1[New Lines Entered]),FILTER(Table1,Table1[Calendar Date]<=EARLIER(Table1[Calendar Date])))-CALCULATE(SUM(Table1[Lines Completed]),FILTER(Table1,Table1[Calendar Date]<=EARLIER(Table1[Calendar Date])))

Total Open Lines with Data = CALCULATE(SUM(Table1[New Data Entered]),FILTER(Table1,Table1[Calendar Date]<=EARLIER(Table1[Calendar Date])))-CALCULATE(SUM(Table1[Lines with Data Completed]),FILTER(Table1,Table1[Calendar Date]<=EARLIER(Table1[Calendar Date])))

Data Percentage = DIVIDE(Table1[Total Open Lines with Data],Table1[Total Open Lines])

Here is my test pbix: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EUjge7rleNZCme1QkqZxfIYBpPSvFnHIRSiOrvkyukwbMQ?e=EdFK6i

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.