Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |