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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

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.

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,

 

 

v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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