Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 | ? | ? | ? | ? | ? |
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)
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |