How to create a Running total - with text items in multipuile columns

[Anonymous]

Hi All.  I'm reasonably new to power BI (Last 2 months), but an expireneced excel person. @XX years . 🙂 

the forum has been great source of guidance to getting my first dashboard up and running - so thank you all.

OK my problem 

I want to create a standard line graph showing  a weekly accumlative target vs an actual accumlative (Dummy date is no issue ) - but my data pionts are text. - and relate to when test are being executed.

So my easy option will be to create the table manually in excel and upload 😞  - But I was looking to have it automated.

I have created the bellow formula  That checks if the if the test has been executed  and retuns the week it ws executed (Week 1, Week 2, Week 3, Week 4 

Week of execution = if(or([Execution_status]="Passed",[Execution_status]="Failed"),'Executed vs Execution Date'[Date of Execution],"")

I have tried a A matrix, that worked well, but it was not accumlative .

I have tyried a measure = calculate(sum(@@[@@@]), filter(Allselected(@@@[@@@] <= "text" ))) - but sum won't work with text

So any idea how I can create the the new table / measure so that I have with or without a trend line 🙂

[v-yulgu-msft]

Hi @Anonymous ,

Week of execution = if(or([Execution_status]="Passed",[Execution_status]="Failed"),'Executed vs Execution Date'[Date of Execution],"")

measure = calculate(sum(@@[@@@]), filter(Allselected(@@@[@@@] <= "text" ))) 

---

I was not able to understand above measure formulas, I cannot see [Execution_status]  and  [Date of Execution] in above posted tables. Please illustrate your scenario with sample data (all necessary table and formulas) and desired output. How to Get Your Question Answered Quickly

Best regards,

Yuliana Gu

[Anonymous]

Hi Yuliana Gu  -  OK sorry I guess the request was not as straight forward as it could be. How can I upload the Excel fiels and Power bi dashboard ?

[v-yulgu-msft]

Hi @Anonymous ,

You can upload the Excel file and sample PBIX file onto OneDrive, and paste the shared link here. Do mask sensitive data before sharing.

Best regards,

Yuliana Gu

[Anonymous]

LInk to excle files and dashboard

Hi Yuliana Gu

LInk to the files is above. Hope it helps 

I want to create the LIne graph - from the data in the files without creating a sperate file 

Terry,