How to create a column with incremented values

Question

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&nbsp;NameSalarySalary incrementedJohn Smith2500020000Joe Black3100024800Mark Johnson2600020800&nbsp;I tried to add a measure calling it salary_incremented = 'WorkersSalary'[salary]*0.8but it returns an errorCould you please help me? Thank you

anonymous · Answer

Hello,&nbsp;you cannot use the column directly. Try:Slary_incremented = SUM('WorkersSalary'[salary]) * 0.8&nbsp;Regards

fabiomanniti · Answer

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

anonymous · Answer

I tried it with your table:&nbsp;NameSalaryJohn Smith25000Joe Black31000Mark Johnson26000&nbsp;&nbsp;&nbsp;Make sure that your Data Type of the Salary column is not set to text.&nbsp;Regards

fabiomanniti · Answer

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 doingrent_years = sum('Table'[rent_days])/365but 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.&nbsp;

anonymous · Answer

Hey,&nbsp;&nbsp;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:&nbsp;&nbsp;&nbsp;Mark the post please as solution if this does the trick 🙂&nbsp;Regards

Forum Discussion

How to create a column with incremented values

6 Replies

Related content

Increment Refresh

Create columns group

Incremental refresh

Incremental Refresh

Incremental Refresh on Dataflow sourced from SharePoint

Name	Salary	Salary incremented
John Smith	25000	20000
Joe Black	31000	24800
Mark Johnson	26000	20800