Forum Discussion
Creating a claculated row
Hi team,
Below is the sample data ,how to show the calculated row column by using the below syntax.
| Attributes | Period1 | Period2 | Period3 | Total |
| ab | 100 | 100 | 200 | 400 |
| bc | 100 | 100 | 200 | 400 |
| cd | 100 | 100 | 200 | 400 |
| de | 100 | 100 | 200 | 400 |
| ef | 100 | 100 | 200 | 400 |
| fg | 100 | 100 | 200 | 400 |
| gh | 100 | 100 | 200 | 400 |
| hi | 100 | 100 | 200 | 400 |
| ij | 100 | 100 | 200 | 400 |
| jk | 100 | 100 | 200 | 400 |
| Result | 700 | 700 | 1400 | 2800 |
Result = ab+bc+cd-de-ef+fg+gh+hi-ij+jk
Regards,
Suresh Pantra.
Anonymous what is the logic? Why you highlight some values in red?
Hi Anonymous ,
1) Is all table you show a DAX calculated table? If yes, then your question is easy achievable.2) Or you put data to the table/matrix visual and need to add an extra row with specific logic? If yes, then it is not working in such way.
Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!
You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User GroupsAnonymous so always red one will get extracted?
5 Replies
Anonymous what is the logic? Why you highlight some values in red?
Hi parry2k ,
Thank you for your reply.
Substarct the highlited values and rest need to add.
Logic is need to add a row based on the attributes.
For example, i have 4attributes and in that i need to add 3attributes and substarct 1 attribute and need to show the data in new column.
Regards,
Suresh Pantra.
Anonymous so always red one will get extracted?
Hi Anonymous ,
1) Is all table you show a DAX calculated table? If yes, then your question is easy achievable.2) Or you put data to the table/matrix visual and need to add an extra row with specific logic? If yes, then it is not working in such way.
Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!
You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups