Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have only quarterly data. I want to make it monthly. I currently have data for mar,jun,sep and dec.
i want from jan to dec. Meaning...
for
jan-previousyear dec data
feb-previousyear dec data
mar- actual march data
apr- march data
may-march data
jun- actual jun data
jul-jun data
aug-jun data
sep- actul sep data
oct-sep data
nov-sep data
dec-actual dec data
i following generate missing data by HIC by couldnt succeed, any one help pls
Hi Gautham,
Check the Attachment. May be helpful.
Hi Settu,
When I use your example, it is not still showing the quarter dates after join.
While I debug by renaming Date as Date 1 , I could see all the dates in Date1, but to join(Date instead of Date1) I see quarterly dates only
Load Date(Floor(Addmonths($(vMinDate),RecNo()-1))) as Date1 Autogenerate vMaxDate-vMinDate;
can you help?
Hi Gautham,
is it possible to provide the expected output in excel?
Settu,
Thanks for your help.
If I select ABC it should show sales for all the dates, if I select DEF it should show for all the dates.
If actual data is null, then it should pick from previous available data and show. Currently it is not showing for all the dates in your example.
for selection ABC expected output is
31/12/2014 | ABC | 3000.00 | 2014 | Dec |
31/01/2015 | ABC | 3000 | 2015 | Jan |
28/02/2015 | ABC | 3000 | 2015 | Feb |
31/03/2015 | ABC | 4000 | 2015 | Mar |
30/04/2015 | ABC | 4000 | 2015 | Apr |
31/05/2015 | ABC | 4000 | 2015 | May |
30/06/2015 | ABC | 9000 | 2015 | Jun |
31/07/2015 | ABC | 9000 | 2015 | Jul |
31/08/2015 | ABC | 9000 | 2015 | Aug |
30/09/2015 | ABC | 4000 | 2015 | Sep |
31/10/2015 | ABC | 4000 | 2015 | Oct |
30/11/2015 | ABC | 4000 | 2015 | Nov |
31/12/2015 | ABC | 4000 | 2015 | Dec |
Also, if I select 2014 year it is showing 2015 dates mixed with 2015 in your example
Hi
PFA
May be its help
Thanks Mayil,
May I know why Date and Date 1 is not joining ?
For create cross join