Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have data like below (Pic= 1) where Data Element column is merged (ex: Stage, End Rate, Avg Rate) and i want to apply the same values to the below cells like Pic= 2
i tried this formula but it it is being applied only for 2020 and 2021. I don't know why not applying for others.
If(IsNull([Data Element]),Peek([Data Element]),[Data Element]) as [new_Data Element]
pic=1
pic=2
Hi,
With peek you can search for a column that doesn't exist yet. You have to look for your own field. Try this:
If(IsNull([Data Element]),Peek([new_Data Element]),[Data Element]) as [new_Data Element]
Jordy
Climber
Hi,
With peek you can search for a column that doesn't exist yet. You have to look for your own field. Try this:
If(IsNull([Data Element]),Peek([new_Data Element]),[Data Element]) as [new_Data Element]
Jordy
Climber
Thank you for your suggestion Jordy... it worked 🙂