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 Apr...
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