Forum Discussion

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
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.

raprgz

Microsoft Employee

10 years ago

How can you setup this sort for just month? Without the Month & Year?

ALeef

Resolver II

10 years ago

Yup, RJ's explanation is exactly like I did it - use a helper column with a numerical value and use that as the "Sort As" column.

RJ
Resolver II
10 years ago
ALeef

Have you had a look at my explantion to join two or more dates to one calendar

http://community.powerbi.com/t5/Desktop/Linking-2-or-more-dates-to-one-Master-Calendar-USERELATIONSHIP/m-p/9316

I was confused at first so wrote it down in detail
- ALeef
  Resolver II
  10 years ago
  RJ : Yup! Thats exactly how I did it, good write up.
  
  It ended up not being exactly what I needed for my visualization, but its a really useful way of doing it.

Forum Discussion

Month Columns in PBI Desktop

Related content

Month/Year column

Month to Month Flow Calculation

Create Date column from Year and Month columns

Subtract one month from date column

Month, Week, Day Offset Columns