Forum Discussion
IF Statement, move values between cells
Hi all, I'm trying to come up with the right IF And statement for my power query, but I'm still quite new to the tool and having some troubles when trying to find the right DAX formula. Hopefully...
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.