Forum Discussion
How to create a column with incremented values
Hello, I have a table called WorkersSalary and a field called salary and another field called name. I want to plot another field wich is Salary incremented = salary x 0.8 Name Salary Salar...
Hello,
you cannot use the column directly. Try:
Slary_incremented = SUM('WorkersSalary'[salary]) * 0.8
Regards
No, this doesn't work, I don't understand what number returns but it is definitely wrong
I tried it with your table:
Name Salary
John Smith 25000 Joe Black 31000 Mark Johnson 26000 Make sure that your Data Type of the Salary column is not set to text.
Regards
It is not set to text but, for what I see it is a Sum.
I am having the same problem with another data.I have a field "rent_days" which is the number of days a machine is rented. I must convert this number into years so I'm doing
rent_years = sum('Table'[rent_days])/365
but the output numbers aren't reasonable.
What I'm seing is the rent_days is grouped as a sum.
I don't really know how to change it.
