Forum Discussion

Sean's avatar
Sean
Icon for Community Champion rankCommunity 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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
11 years ago

Create a new column called "MonthSort" or something and use the formula:

 

=FORMAT([Date],"mm")

 

This will give you a two digit number for month.

 

Select your Month column, Modeling tab and choose "Sort by Column" and set it to MonthSort column.

ig23's avatar
ig23
New Member
9 years ago

Thanks for your answer. It worked for me. 

I am just asking myself why it doesn't work when you have 2 digits for a month number column.

 

Thanks in advance.