Forum Discussion

fabiomanniti's avatar
fabiomanniti
Helper III
4 years ago

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...
CALCULATE
fabiomanniti's avatar
fabiomanniti
Helper III
4 years ago

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I tried it with your table:

 

Name

Salary

John Smith25000
Joe Black31000
Mark Johnson26000

 

 

 

Make sure that your Data Type of the Salary column is not set to text.

 

Regards

  • fabiomanniti's avatar
    fabiomanniti
    Helper III
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        fabiomanniti
        Helper III
        4 years ago

        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.