Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

change data of 1 cell in a table

Hi all,

 

I have a data set that help me to make this summary table like this:

summary.png

I face some issues hope people can help:

 

1/ I need to change the data of EBITA in column "CY" (current year) = External Revenue - Expense.

2/ I need to create another row within Total Hours that show Ultilization rate = chargeable hours/ total hours.

 

Is there a way that I can show these request in a same table? I'm thinking about using SWITCH syntax but not sure whether it could work.

 

Best regards,

1 ACCEPTED SOLUTION
MattAllington
Community Champion
Community Champion

Well, it depends on how you have built what you have got already. I suspect that the technique covered in this video should help you. http://www.youtube.com/watch?v=ojHZkWkEY7Q/

 

Take note of the header table and how Derek switches between running totals and line totals. I think you can use this technique to do what you want. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Thanks  @MattAllington,

 

The link is quite helpful but it's a bit old since they demonstrate it on Power pivot instead of Power BI. But it really got to the point.

 

I found some useful links that are more relavent to Power BI instead:

https://www.managility.co/profit-loss-dynamic-sub-totals-in-power-bi-excel-dax/

https://www.daxpatterns.com/cumulative-total/

 

Thanks,

 

 

Anonymous
Not applicable

Hi @Anonymous ,

You can refer to following links to know how to use if statement to check current row contents and replace specific level calculation formula:

Measure Totals, The Final Word

Regards,

Xiaoxin Sheng

MattAllington
Community Champion
Community Champion

Well, it depends on how you have built what you have got already. I suspect that the technique covered in this video should help you. http://www.youtube.com/watch?v=ojHZkWkEY7Q/

 

Take note of the header table and how Derek switches between running totals and line totals. I think you can use this technique to do what you want. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.