+ Reply to Thread
Results 1 to 2 of 2

Concatenating Notes Field in Powerpivot

Hybrid View

  1. #1
    Registered User
    Join Date
    06-24-2024
    Location
    Virginia, USA
    MS-Off Ver
    2404
    Posts
    2

    Concatenating Notes Field in Powerpivot

    Hello I have a financial budget rollup model in powerpivot. My facts table with all the projected budgets per account and per business unit has notes from the people who put the budget together. The rollup displays information for all the business units together but can be filtered down to individual business units too. I want to concatenate the notes on the GL code as a measure but can't figure out how to make it work. So depending on the filtering of the table it would match the financial information presented. Any help with this concatenate measure? I tried concatenate x with a variety of calculate and such but couldn't get it to work.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,773

    Re: Concatenating Notes Field in Powerpivot

    Is 2404 Excel 265? If so, please add this to your profile. Thanks.

    There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

+ 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. Add calculated field to a powerpivot table?
    By Dek888 in forum Excel General
    Replies: 3
    Last Post: 03-22-2021, 05:27 PM
  2. [SOLVED] PowerPivot: Merge Month Field and Year Field Into a Date Field
    By mo4391 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-17-2015, 11:59 AM
  3. PowerPivot calculated field
    By trisoldee in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-26-2015, 11:20 AM
  4. [SOLVED] PowerPivot calculated field error
    By trisoldee in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-19-2015, 02:42 PM
  5. New calculated Field in Powerpivot
    By ehardway111 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-22-2013, 03:07 PM
  6. Notes within each field
    By CastorRJ1 in forum Excel General
    Replies: 4
    Last Post: 10-24-2009, 10:43 AM
  7. Breaking down a notes field
    By icw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2007, 01:00 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