esamFrequent Visitor3 years agoSolvedMonth Series Hi I have date table from 2023 to 2025 i want a column with month series where 36 being december 2025 and 1 being January 2023. FreemanZ to esam3 years agohi esam tAha, try likeMonth Series =DATEDIFF(DATE(2023, 1, 1), [Date], MONTH)+1
FreemanZ to esam3 years agohi esam tAha, try likeMonth Series =DATEDIFF(DATE(2023, 1, 1), [Date], MONTH)+1
FreemanZ to esam3 years agohi esam tAha, try likeMonth Series =DATEDIFF(DATE(2023, 1, 1), [Date], MONTH)+1
smpa01Community Champion3 years agoesam not sure what your Date table looks like, I simply Assumed that you have only 1 column table as Calendar[Date] Column = RANKX ( 'Calendar', DATE ( MONTH ( 'Calendar'[Date] ), YEAR ( 'Calendra'[Date] ), 1 ), , ASC, DENSE )
Related contentTime series by date, week, month-yearMonth to Month Flow CalculationGenerate Series of month and yearsCan't change series color in ribbon chartCounting Active employees per month
