How to enter formula for each row.

[aryan]

Hi,

I am facing a problem,I have three different columns as column A,B,C. I took a custom column in the custom column, i need first row as Sum of column A, in second row i need sum of column B, in third row i need sum of Column C how to calculate this

Plz help me out

Thanks in advance

[erikajain02]

Please share some sample data and desired output ..!!

[mattluk]

you can click "edit queries" in home tab and click "customer column" in add column tab

[aryan]

I need to display a table report with sum of different column as one column

how can i do that

[erikajain02]

Sorry Aryan,

your requirement is not very clear to me untill you post some sample data of around 10 rows and desired output format.

If you only want the totals of all three columns in just one table .

You can three measures for each of the columns total.

then choose Matrix and drag the three measures in it.

then u can choose Format tab : "Show on rows : on " State. 

[aryan]

consider this as my report

	Total
Sum of customers	4
Sum of Other charges	120
Sum of charges	360

this my table

customers	charges	Other charges
1	100	50
2	30	10
3	100	20
4	130	40

 from this table i need to develop the above report 

[erikajain02]

Add 3 Measures: 

Sum of Other Charges = Sum(Table1[Other charges])
Sum of Customers = DISTINCTCOUNT(Table1[customers])
Sum of charges = Sum(Table1[charges])

The add a Matrix :

Add the three Measures in it.

 Go to Format option > Value > Show on Row : On

[aryan]

	codes	Total
Sum of customers	2	7
Sum of Other charges	3	120
Sum of charges	4	360

 i tried using matrix it should look like this

[erikajain02]

You can achieve this by creating a new table This table will remain island and will not link to any other table in the model.

 then in Report View :

U can create a Matrix  with dimension as Attribute .

Now create 2 measures :

Sum = if(MAX([Sort])=1,[Sum of Customers],if(MAX([Sort])=2,[Sum of charges],[Sum of Other Charges]))

Count = if(MAX([Sort])=1,DISTINCTCOUNT(Table1[customers]),if(MAX([Sort])=2,DISTINCTCOUNT(Table1[charges]),DISTINCTCOUNT(Table1[Other charges])))

You can edit logic / calculations as per your requirement.

[aryan]

can we enter data in to custom column in power bi like for custom column      count

                                                                                                                                  1

                                                                                                                                  2

                                                                                                                                  3

                                                                                                                                  4

                                                                                                                                  5

                                                                                                                                  6

[v-piga-msft]

Hi @aryan,

It seems that your initial requirement have been solved. Please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

---

@aryan wrote:

can we enter data in to custom column in power bi like for custom column      count

                                                                                                                                  1

                                                                                                                                  2

                                                                                                                                  3

                                                                                                                                  4

                                                                                                                                  5

                                                                                                                                  6

---

In addition, do you want to create a custom column like above in Query Editor?

If you want to create that column, you could go to Editor Queries——Add Column——Index column.

If you need additional help, please share your desired output.

Best  Regards,

Cherry

[aryan]

can we data in to column from edit query like for column              count

                                                                                                              1

                                                                                                              2

                                                                                                              3

                                                                                                              4

                                                                                                              5

                                                                                                              6 

[erikajain02]

Hope This helps !!!!

[aryan]

Thank u very much but if want to insert codes in between that 2 columns

[mattluk]

you can click the table and add the values which colum data you whant, and select sum