Forum Discussion

Py0809's avatar
Py0809
Frequent Visitor
4 years ago
Solved

How to generate a table with dynamic starting month

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...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    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.

     

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

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.