How to create a column with incremented values

[fabiomanniti]

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	Salary incremented
John Smith	25000	20000
Joe Black	31000	24800
Mark Johnson	26000	20800

I tried to add a measure calling it salary_incremented = 'WorkersSalary'[salary]*0.8

but it returns an error

Could you please help me? Thank you

[Anonymous]

Hello,

you cannot use the column directly. Try:
Slary_incremented = SUM('WorkersSalary'[salary]) * 0.8

Regards

[fabiomanniti]

No, this doesn't work, I don't understand what number returns but it is definitely wrong

[Anonymous]

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

[fabiomanniti]

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.

[Anonymous]

Hey, 

you can change that in the table view. Select the column with the sum-icon in front and change it above to Do not summarize. See below:

Mark the post please as solution if this does the trick 🙂 

Regards

[fabiomanniti]

No, I can't because the option is greyed out. I believe it is because I'm not the one who created the table but I used a dataset someone else imported. I don't know.