topic Re: How to create a column with incremented values in DAX Commands and Tips

How to create a column with incremented values

fabiomanniti — Tue, 07 Sep 2021 16:24:06 GMT

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

Re: How to create a column with incremented values

Anonymous — Tue, 07 Sep 2021 20:15:25 GMT

Hello,

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

Regards

Re: How to create a column with incremented values

fabiomanniti — Wed, 08 Sep 2021 16:18:09 GMT

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

Re: How to create a column with incremented values

Anonymous — Wed, 08 Sep 2021 19:29:21 GMT

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

Re: How to create a column with incremented values

fabiomanniti — Thu, 09 Sep 2021 13:19:27 GMT

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.

Re: How to create a column with incremented values

Anonymous — Thu, 09 Sep 2021 18:55:43 GMT

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

Re: How to create a column with incremented values

fabiomanniti — Fri, 10 Sep 2021 09:34:16 GMT

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.