Forum Discussion
IF Statement, move values between cells
Hi,
not sure of how you have labelled you columns or structure of your data, since you are not sharing any screen shots, pbix-file og data table.
I have created an example of how it could be done if you have the columns OrderYear, OrderSum, OrderYear+2,...., OrderYear+4, attached at the bottom of my reply
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
Amazing – this helped, thank you sturlaws ! Perhaps you would be able to advice on the next step too, which I’m working on now…
To see the years the values refer to, I created a few more year columns - please see image 1. I then wanted to calculate the total value for each Order Year, which I’ve done by referencing the main table, then grouping and merging – please see the final outcome in image 2. However, my issue now is that when creating a line chart within the desktop is that the values cannot be filtered by data in the initial table due to the change in columns. I’ve probably overcomplicated the process for myself, but is there an easier way around this or a way where I can create a link between the Total Values table and initial table?
Many thanks!
Image 1Image 2