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
johnt75Super User to esam3 years agoOK, the below works for me Month series = VAR ReferenceDate = 'Date'[Date] VAR PrevMonths = CALCULATETABLE ( DISTINCT ( 'Date'[Year month] ), REMOVEFILTERS ( 'Date' ), 'Date'[Date] <= ReferenceDate ) RETURN COUNTROWS ( PrevMonths )
Related contentTime series by date, week, month-yearMonth to Month Flow CalculationGenerate Series of month and yearsCan't change series color in ribbon chartMonth over Month with multiple text values
