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.

LanceDelano's avatar
LanceDelano
Icon for Microsoft Employee rankMicrosoft Employee
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.

apamau's avatar
apamau
New Member
11 years ago

Yes, pls make it easier to auto detect or let us mark and easily inform the system this is month, year, a date or what ?

thanks and hope that's coming in fast.

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      I am too having this issue, surly it is a basic problem?

  • dexterz's avatar
    dexterz
    Icon for Helper II rankHelper II
    9 years ago

    Date =ADDCOLUMNS (

        CALENDAR ( "2010-01-01", "2014-12-31" ),

        "Year", FORMAT ( [Date], "YYYY" ),

        "Quarter", "Q" & FORMAT ( [Date], "Q" ),

        "Month", FORMAT ( [Date], "MM" ),

        "Month", FORMAT ( [Date], "MMM" ),

        "Weekday", FORMAT ( [Date], "ddd" ),

        "WeekdayNum", WEEKDAY ( [Date], 2 ),

        "Day", FORMAT ( [Date], "dd" ),

        "Cal-Month", FORMAT ( [Date], "YYYY-MM" ),

        "Cal-Month", FORMAT ( [Date], "YYYY" ) & "-Q"

            & FORMAT ( [Date], "Q" ))

    • teylyn's avatar
      teylyn
      Icon for Advocate III rankAdvocate III
      9 years ago

      amysmith, you are not attempting to answer the question. The link just leads to a generic landing page in your site. I assume you posted that link to attract traffic. I have reported your post as spam.