Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have a table below:
Id | Year-Month |
---|---|
1 | 201601 |
2 | 201604 |
3 | 201611 |
4 | 201703 |
I would like to generate the table below:
Header 1 | Header 2 | |
---|---|---|
1 |
| |
1 |
| |
1 |
| |
1 |
| |
1 |
| |
1 |
| |
1 |
| |
1 |
| |
1 |
| |
1 |
| |
1 |
| |
1 |
| |
1 |
| |
1 |
| |
1 |
| |
1 |
| |
1 | 201705 |
Other Record also generate until today year month.
Best Regards,
Louis
Anyone can help?
Hi Louis,
LOAD ID,
Date(AddMonths(Date#(YearMonth,'YYYYMM'),IterNo()-1),'YYYYMM') as YearMonth Inline [
ID,YearMonth
1,201601
2,201604
3,201611
4,201703
] While Date(AddMonths(Date#(YearMonth,'YYYYMM'),IterNo()-1),'YYYYMM') <= Date(Today(),'YYYYMM');
Regards,
Antonio