Forum Discussion
Helper ICreate personnalized column with calcul between two columns in two different table
Hello,
hope you are all well,
I need help, i would like to create a new column with calcul : in both table we have the same number of lines and we have relation between table (month in both tables). So i want to create a new column with calcul division between theses tables : "Total Value" / "Rel. Value"
How can i do ?
Thank you very much
Regards
Hi ANB_13 ,
Please try merge queries and first and then add a custom column.Merge queries.
Sum of rel. value.
Add a custom column.
It is not clear what your expected output is, and you can also expand it directly in the second part instead of summing.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
2 Replies
Hi ANB_13 ,
Please try merge queries and first and then add a custom column.Merge queries.
Sum of rel. value.
Add a custom column.
It is not clear what your expected output is, and you can also expand it directly in the second part instead of summing.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
ANB_13Thank you very much 🙏