Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Opening Balance where Month periods are not calendar date

-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

nikilouw_0-1595576419434.png

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

nikilouw_1-1595576569565.png

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


Can anybody help met please?

5 REPLIES 5
amitchandak
Super User
Super User

@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
Not applicable

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

nikilouw_0-1595579871820.png

 

Anonymous
Not applicable

Hi @amitchandak 

Could you have a look at my response. please?

 

Thank you in advance

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

Anonymous
Not applicable

@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?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.