Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
I have a data set that help me to make this summary table like this:
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,
Solved! Go to 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.
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,
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
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
92 | |
89 | |
70 | |
69 |
User | Count |
---|---|
228 | |
128 | |
117 | |
83 | |
82 |