Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the below script wanted to know the difference between Peek and Previous functions
So when Iam trying that, the end result is same for both functionalities. Could anyone of you please help me with this.
Test:
load
Distinct(Month) as Month_1,
SaleAmount,
Previous(SaleAmount) as Previousamount,
peek(SaleAmount) as Peek_amount;
test1:
load *
Inline [
Month,SaleAmount
Jan,100
Feb,200
Mar,300
Apr,400
May,500
Jun,600
Jun,600
];
Output for the script :
There is a detailed explanation of the difference here
https://www.naturalsynergies.com/q-tip-12-peek-or-previous/
There is a detailed explanation of the difference here
https://www.naturalsynergies.com/q-tip-12-peek-or-previous/
Thank you!!