Opening Balance where Month periods are not calendar date

[Anonymous]

-I am trying to create a measure that calculates an opening balance for each month.
-The month periods differ i.e. not all months are 1st to 30/31st
-I have a date table where the month periods are defined eg January is 25 Dec to 23 Jan, Feb is 24 Jan to 22 Feb

- The fact table is joined via the "PeriodNoSK" dimension:

- the opening balance would thus be all rows with PeriodNoSK up till the PeriodNoSK -1 per the DateTable

Can anybody help met please?

[amitchandak]

@Anonymous , Can you share sample data and sample output in table format?

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Anonymous]

Hi @amitchandak 
Thank you for the prompt response.
I hope this helps.

[Anonymous]

Hi @amitchandak 

Could you have a look at my response. please?

Thank you in advance

[amitchandak]

@Anonymous , Can you share sample data and sample output in table format? Seem like need write some code 😀

[Anonymous]

@amitchandak 

definetely need code 🙂
I cant share my data, but I have given an example I did in Excel in the thread above - can you work from this?