Creating new rows with for loop in load script

[mfarsln]

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.

[JordyWegman]

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