Forum Discussion

Sean's avatar
Sean
Community Champion
11 years ago
Solved

Month Columns in PBI Desktop

I noticed that when I load my data directly into PBI Online I automatically get YEAR and MONTH columns added next to all DATE columns I have! What is even better is that this MONTH column that PBI On...
  • LanceDelano's avatar
    LanceDelano
    11 years ago

    We're currently working on this for the desktop .... and it will be a unified experience in both the desktop and service.  There are several date time features that will show up.  This kind of automatic behavior is among the first that will arrive.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Any news on when this will be rolled out?

EZgrafton's avatar
EZgrafton
Advocate II
9 years ago

I don't know if you found a solution for this, but if you didn't just follow these simple steps:

  1. create a table with the months / year
  2. assign a numerical order to them (1, 2, 3, etc.)
  3. link the month / year field on the newly created table to the month / year field on your original table
  4. sort the month / year field on your original table by the numerical order you created on 2

It should work. :)