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 am new in Power Bi. Please I need to create a new column with the division between of Sum of PrecioTotal and Count of Razon.
Thanks for your help
CodVend | Sum of PrecioTotal | Count of Razon |
1 | $3.57 | 2 |
2 | $6.90 | 3 |
3 | $11.23 | 3 |
4 | $12.26 | 3 |
5 | $16.84 | 4 |
Solved! Go to Solution.
Hi @Anonymous,
If above sample table is the original data table in excel worksheet, you can refer to below DAX to create a calculated column.
Column = DIVIDE(Table9[Sum of PrecioTotal],Table9[Count of Razon])
If above table is the output in table visual, and the source table contains columns [CodVend], [PrecioTotal] and [Razon]. You can add below measure to table visual.
Measure=SUM(Table9[[PrecioTotal]])/SUM(Table9[Razon])
Best regards,
Yuliana Gu
Hi @Anonymous,
If above sample table is the original data table in excel worksheet, you can refer to below DAX to create a calculated column.
Column = DIVIDE(Table9[Sum of PrecioTotal],Table9[Count of Razon])
If above table is the output in table visual, and the source table contains columns [CodVend], [PrecioTotal] and [Razon]. You can add below measure to table visual.
Measure=SUM(Table9[[PrecioTotal]])/SUM(Table9[Razon])
Best regards,
Yuliana Gu
Hi,
Paste your source data here.
My source data is a excel spreadsheet.
The table of the message is the data of that spreadsheet.
Thanks for your help
Hi,
If the Table in your original post is also your source data, then write this calculated column formula
=[Sum of PrecioTotal]/[Count of Razon]
Hope this helps.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |