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.
I want for each ID (row) to show a total for (column_name_1) calculated by (column_name_2) and (column_name_3)
i ask for ideas how to do it
thanks
Hi galina,
I don't know your data sample, so if possible, could you please inform me in details?
Below is my design, if this is not what you want, please correct me and inform me your data sampel and expecting output
name | id | cost | quantity |
a | 1 | 10 | 2 |
a | 2 | 5 | 1 |
a | 3 | 3 | 5 |
a | 4 | 2 | 4 |
b | 1 | 5 | 3 |
b | 2 | 6 | 1 |
b | 3 | 2 | 2 |
b | 4 | 3 | 1 |
c | 1 | 1 | 2 |
c | 2 | 2 | 3 |
you could create a column like below
Column = sumtotal[cost]*sumtotal[quantity]
then add this in Matrix
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I want a different total for each row.
the columns are those:
'TableName'[1st year]
'TableName'[Group]="CAPEX",
'TableName'[Group]="OPEX",
'TableName'[Type]="Indicative"
'TableName'[Type]="Estimation"
'TableName'[ID]
I want to get something like that:
id|1st year|Indicative|CAPEX
Hi
If possible, could you please inform me more detailed information(sample data and expecting output)?
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |