I have a list of Journal postings (transactions) which have a GL code / Value / Period / Year and Journal date
Now I want to calculate the movements and the YTD movements based on the period and show it in a matrix. The YTD movements are the OpeningBalance of the GL code + the movements.

The problem I am struggling with is that, my matrix has to use the period as columns but I am now not sure how to deal with the YTD measure I would like to calculate as I cannot use the the TOTALYTD function as my data is not filtered on dates but on period. The postings can happen for example in July and august but are still posted to period 1.

I use the dates, but thats not correct as it should filter on the periods but not sure how that could work?
I am a bit lost how to reason about the “PTD” movements as its based on the GL periods
so for Period 3, the PTD movements are movements of period 1 + period 2 + period 3.
So when using this in a matrix, it should be clear for the measure which period it has to calculate
the Movements.

Not sure if its all clear what I am after but this is

So somehow I can link the period to the datestable as it is mostly the last day of the month.

The second question was then the following:

Each GLcode has an openingbalance at the start of the year.

eg. 001010 ==> 90K

Then what I want to calculate is the YTD based on this opening balance (which is fixed) and the runningtotal of the movements.

So YTD period 1 = OpeningBalance + RunningValue(Movements)
This was the formula i was using in SSRS and that worked somehow.

Not sure if my running total value will be correct when putting it into a matrix form.

Sorry for the questions but I am sometimes a little lost in how to reason about the dax formulas
especially when linking calculations with slicers later on and see how they influence the calculation.

Ok I found a table where the period ends are set.
Any standard way how i could fold that into the Dates table?

The setup is like this.

Name Period end date
Period 1 , 2018-07-31 00:00:00.000
Period 2 , 2018-08-31 00:00:00.000

etc…

I should somehow generate a full table now based on these period end dates.
Not sure how to do it in DAX though at the moment. Will have to think about it.