topic Re: Dax Formula For Sum Rows in DAX Commands and Tips

Dax Formula For Sum Rows

S44MSM — Sun, 17 May 2020 16:11:53 GMT

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	?	?	?	?	?

Re: Dax Formula For Sum Rows

Greg_Deckler — Sun, 17 May 2020 16:25:25 GMT

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.

Re: Dax Formula For Sum Rows

S44MSM — Sun, 17 May 2020 16:55:57 GMT

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

Re: Dax Formula For Sum Rows

Anonymous — Mon, 18 May 2020 04:04:45 GMT

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!!

Re: Dax Formula For Sum Rows

Anonymous — Mon, 17 Aug 2020 12:17:20 GMT

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)