How to generate a table with dynamic starting month

[Py0809]

Hi,

I have monthly data with different starting month as shown below:

The starting month depends on which cycle it belongs to. For e.g. when we are looking at Apr cycle, the starting month will be April with a 12-months period cycle. 

Now, I would like to combine all these tables with different starting month into one table so that I can use it to display my data in table visual in Power BI. 

How should I generate a table that can capture the demand & supply for different cycle? Thanks. 

[v-chenwuz-msft · Accepted solution]

Hi @Py0809 ,

Is that you want something like this gif shows?

If yes, please create an indepened date table for this slicer and subscribe the measure in the value of martix table.

Measure:

Measure =
VAR _s =
    MIN ( 'slicer table'[Date] )
VAR _e =
    DATE ( YEAR ( _s ) + 1, MONTH ( _s ), 1 ) - 1
RETURN
    CALCULATE (
        SUM ( Facttable[VALUES] ),
        FILTER ( 'Facttable', [Date] >= _s && [Date] <= _e )
    )

Pbix file in the end which you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.