+ Reply to Thread
Results 1 to 7 of 7

a lookup formular in convert my daily data into monthly data

Hybrid View

  1. #1
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,420

    Re: a lookup formular in convert my daily data into monthly data

    Power Query
    let
        Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
        #"Changed Type" = Table.TransformColumnTypes(Source,{{"Result:", type date}, {"Numbers", Int64.Type}}),
        #"Calculated Start of Month" = Table.TransformColumns(#"Changed Type",{{"Result:", Date.StartOfMonth, type date}}),
        #"Grouped Rows" = Table.Group(#"Calculated Start of Month", {"Result:"}, {{"Count", each List.Max([Numbers]), type number}})
    in
        #"Grouped Rows"
    Attached Files Attached Files

+ 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. Convert Daily Data to Monthly Data
    By JohnArrow21 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-28-2021, 03:48 PM
  2. Convert monthly row data into single column daily data
    By chsaleem in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-29-2019, 04:17 AM
  3. Convert monthly row data into single column daily data
    By chsaleem in forum Excel General
    Replies: 3
    Last Post: 11-29-2019, 04:16 AM
  4. Replies: 11
    Last Post: 06-06-2018, 05:08 PM
  5. Convert daily sales data into monthly for many years
    By ibrahimdaas in forum Excel General
    Replies: 4
    Last Post: 04-11-2018, 04:35 PM
  6. [SOLVED] Formula to Group analytical data imputed daily into daily weekly and monthly analysis.
    By tianasamour in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-13-2015, 06:10 PM
  7. Replies: 3
    Last Post: 10-01-2013, 05:05 AM

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