+ Reply to Thread
Results 1 to 3 of 3

Power Query Date Transformation

  1. #1
    Registered User
    Join Date
    11-05-2015
    Location
    England
    MS-Off Ver
    2010
    Posts
    43

    Power Query Date Transformation

    Hi,

    I have downloaded social data and one of the metrics is 'followers gained by month'. However when the data pulls through, for the month it appears as '02/01/2018-02/28/2018' so February 2018.

    How would i transform this to be 01/02/2018 (UK) or just February 2018?

    When i click transform to date it appears as an error.

    Any help would be great!

  2. #2
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: Power Query Date Transformation

    Just select the column, press CTRL+H, Find what: -* [dash star] Replace with: [null]

  3. #3
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be anywhere in the world
    MS-Off Ver
    power BI
    Posts
    9,005

    Re: Power Query Date Transformation

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. error in power query & power pivot
    By Baldev Kumar in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 01-03-2018, 01:34 AM
  2. Replies: 3
    Last Post: 12-03-2017, 01:41 PM
  3. Data transformation using Formula or Power Query
    By chullan88 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-18-2017, 09:59 AM
  4. Power Query Date Time
    By jcmckeon in forum Excel General
    Replies: 5
    Last Post: 09-12-2017, 02:19 PM
  5. Problem: DAX or Power Query best resolution - Date Range Calc
    By happydays886 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2017, 01:18 AM
  6. Power Query - Filter by Date
    By brent_milne in forum Excel General
    Replies: 0
    Last Post: 03-16-2017, 10:39 AM
  7. Power Query convert Unix time to a date
    By logisteve in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2015, 06:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1