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
FreemanZSuper User3 years agohi esam try to add a column like:Month Series =DATEDIFF([Date], DATE(2023, 1, 1), MONTH)+1
Related contentMonth to Month Flow CalculationTime series by date, week, month-yearGenerate Series of month and yearsMonth over Month with multiple text valuesCounting Active employees per month