Forum Discussion
Split one column for another
Hello I go on to describe my problem.
I need to divide month by month the Total column without taxes of the Vtas Day table by (1- the cumulative inflation column of the Inflation 2022 table).
The relationship of the tables is as follows;
The Vtas Dia table and the 2022 Inflation table are related by date.
What I would like to do is get a table that is as follows
| My | Sales | Cumulative inflation | Inflation-adjusted sales |
| January | 100 | 0.05 | 105.23 |
| February | 110 | 0.1 | 122.22 |
2 Replies
Hi Syndicate_Admin ,
It's not clear to me which table and which field your final example output came from. Could you please describe more clearly ablout the calculation logic of Inflation-adjusted sales?
And it will be helpful if you can provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Community Support Team _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Now simplify the formula a little
For better understanding the values I need are in different tables.
Create this display table to make it look better.
I need to divide the Amount Sum column and the Coefficient column month by month.
What I would like to get is the following
My Amount Coefficient Inflation-adjusted sales
January 150 1.04 144.23 February 90 1.09 82.57 ... .... ... .... ... The file (.pbix) and (.xlsx) cannot be uploaded.
