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 😃

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

        I would not say I am a total neophyte but how can a Microsoft write such a software that cannot interpret chronological dates..I guess that is life!

        thanks again!