Forum Discussion

Frequent Visitor

3 years ago

Solved

Month 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
3 years ago
hi esam
t
Aha, try like
Month Series =
DATEDIFF(DATE(2023, 1, 1), [Date], MONTH)+1

Super User

3 years ago

try to add a column like:

Month Series =

DATEDIFF([Date], DATE(2023, 1, 1), MONTH)+1

esam
Frequent Visitor
3 years ago
Hi FreemanZ
The solution you provided gave something similar but not accurate it is giving me result in negative
for jan 2023 it is one than feb 2023 0 and for december 2025 -33
- FreemanZ
  Super User
  3 years ago
  hi esam
  t
  Aha, try like
  Month Series =
  DATEDIFF(DATE(2023, 1, 1), [Date], MONTH)+1
  - esam
    Frequent Visitor
    3 years ago
    Thank you for the solution FreemanZ can you explain a bit how this logic is working here !!
    also how to get better with dax with real world scenarios

Related content