Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have a table which has months as dimensions. I want to loop through all months and create new rows in another table by concatenating current month and previous month.
For April, i want to generate "April / March" or "4 / 3" and so on. Then i will use this new dimension for getting the % differece between two months.
I've tried something but it didn't do the trick.
Hi,
You don't need a loop for this, and why do you want to concatenate this to another table? Maybe you can try this?
Calendar:
Load
*,
Month &'|'& Previous(Month) as MonthCombination
Load
*
From [Your Source]
;
Jordy
Climber