Forum Discussion

Karolina411's avatar
Karolina411
Icon for Helper V rankHelper V
4 years ago

Date mismatches

Hello So...my date column in my date dimension is not working all of a sudden----I tried to ensure both are dates only but that is not working - when I use MONTHDATE (as below) it cannot get into da...
Date Issues DateTime
Karolina411's avatar
Karolina411
Icon for Helper V rankHelper V
4 years ago

I can hardly understand how he wrote those complex instructions....how can there be  a program that does not sort dates in chronological order?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Right Click "DIMDATE", Add a new column, and type in the following code:

     

    yearMonth = RIGHT(YEAR('DIMDATE'[DateValue]),2) &
    SWITCH(MONTH('DIMDATE'[DateValue]),
    1,"01",
    2,"02",
    3,"03",
    4,"04",
    5,"05",
    6,"06",
    7,"07",
    8,"08",
    9,"09",
    10,"10",
    11,"11",
    12,"12"
    )

     

    Then Left Click the "FormattedMonthYear" under "DIMDATE" and sort the column by "yearMonth"

     

     

    • Karolina411's avatar
      Karolina411
      Icon for Helper V rankHelper V
      4 years ago

      Thank you ..I will try this later today...appreciate the clarity

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        No problem, I'm new to Power BI as well and I faced the same problem a few days ago. That was the way I solved it. Hope it can solve yours as well 😃