Forum Discussion
Solved
Help with replacing Value on one Column based on Historical Values and another column
Hello, I have a data where we are tracking figures for different models on monthly basis. These models are based on the month name. In my sample data here, Model column represents that and 202304...
Okay, I was able to solve this. Thanks!
Okay, I was able to get two measures with correct values.
FC just like I showed earlier
And also AC with value 104 in 202304 and remaining empty cells in other columns
But in this table I can see one row for FC and another row for AC.
How can I combine the two measures or overlap the two measures that AC of 104 on 202304 column sits on FC of 202304? In other words, I would like to see just one row having FC Values in all columns except for 202304 and AC Value in that place within same row.
Any help to merge the two measures would be super helpful.
Thanks!
Okay, I was able to solve this. Thanks!