Forum Discussion
Dax Formula For Sum Rows
Hi I'm new to Power Bi so this probably is a really simple question
All i am trying to do is add a sub total column to add up the vales for each day
| 06 April 2020 | 07 April 2020 | 08 April 2020 | 09 April 2020 | Total | |
| Day Rate | 71590 | 17492 | 17918 | 17386 | 70258 |
| Plant | 7601 | 7391 | 7391 | 7391 | 29775 |
| Fuel | 3900 | 3850 | 3950 | 3850 | 15550 |
| Materials | 9888 | 8404 | 9888 | 8569 | 36749 |
| Sub Con | 27900 | 27369 | 31294 | 27741 | 114303 |
| Total | ? | ? | ? | ? | ? |
4 Replies
If your source data is actually formatted like that, unpivot all of your day columns so that you end up with 2 columns. Then you can use a matrix visualization and not do any work what-so-ever.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.I have used the matrix visulisation tool, to pull the data to make this table
My data isnt set out in this table, the tabel is a result of the matrix
Hi S44MSM ,
Assuming that your table looks like this.
Convert the attribute column to Date/Time.
Pull the matrix visualization, to get the desired output.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!
Hi S44MSM ,
Did the solution work for you.
Please mark as solution for other community members to benefit.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
