Forum Discussion
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 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.
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.
1 Reply
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.