Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I have taken Date as dimension and sum(Application_sales) as Measure. I need to consider last day sales if i dnt have sales on that day.
For example,
Date, Sales
01-04-2018 , 200
02-04-2018, 400
03-04-2018, 0
04-04-2018,0
05-04-2018, 600
Here, I need to show sales of 02-04-2018 ( 400 ) to 03-04-2018 and 04-04-2018 also. please find the attached image.
Please help me in this.
Thanks.. Tulasiram
For front-end solution, try like:
You can try loading like:
Load Date,
If(Sales=0, Peek(Sales), Sales) as Sales
For front-end solution, try like:
Hello Tresesco,
It is working fine. Thank you so much.