+ Reply to Thread
Results 1 to 3 of 3

CONCATENATEX Values not showing up?

  1. #1
    Forum Contributor NewYears1978's Avatar
    Join Date
    03-15-2010
    Location
    Forney, TX
    MS-Off Ver
    Excel 2016
    Posts
    962

    CONCATENATEX Values not showing up?

    I have had this happen on multiple occasions but I am not sure the cause.

    I have a pivot based on a very large dataset (800k rows) and there are some number values but also some text strings, so I use CONCATENATEX to convert those to text so I can include them in the pivot table.
    Sometimes when I create it then drag it to values, nothing happens. It processes then just nothing happens.

    Is there a data size limit to how much this can handle or is there another known issue that could cause this?

    Example of the customer measure:
    Please Login or Register  to view this content.
    The measure is right as far as I know, I always use this same formula, unless I am making a typo or something?

    Thanks in advance!

    Edit: I think I may have just fouled up the DAX, should be =CONCATENATEX(Values(Table1[CustomerName]), Table1[CustomerName], ", ")

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: CONCATENATEX Values not showing up?

    Here is a link on the way to use Concatenatex

    https://sfmagazine.com/post-entry/ju...a-pivot-table/
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor NewYears1978's Avatar
    Join Date
    03-15-2010
    Location
    Forney, TX
    MS-Off Ver
    Excel 2016
    Posts
    962

    Re: CONCATENATEX Values not showing up?

    @alansidman

    Thanks I am using it successfully but turns out the issue is when I have a lot of rows, it will not put the data in the table.
    My files generally have 800k rows and I put in my calc field and drag to values, it calculates but then nothing happens. Are there any work arounds for this?

    I would love to post a sample file, but 800k row files are 300mb so I cannot. Anyone have any ideas or is my only work around to transform with power query or use a different software (Power BI or something)?

    Thanks in advance!

    (Edit: I believe what is happening is possible the totals cell is over the 32k characters that is mention in the article, and I had read about this issue before..but I turn those total cells off so I figured that should have eliminated that issue...but maybe it still "calculates" them in the background and causes the pivot to become unresponsive? If I change to top 10 or top 1000 or top 100 or something, the field appears..but I need it to work properly for all my data... apparently an issue for many years in Excel and Microsoft won't fix it)
    Last edited by NewYears1978; 05-09-2022 at 02:59 PM.

+ 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. CONCATENATEX in Values - Order Problems
    By GoldenChicken in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-24-2023, 03:51 AM
  2. [SOLVED] Concatenatex and bulleted list
    By bam500 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-06-2022, 08:01 AM
  3. Problem with CONCATENATEX measure in pivot table
    By Jayjay33 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-17-2021, 08:24 PM
  4. [SOLVED] CONCATENATEX and Using Slicer Value in FILTER
    By swong1709 in forum Excel General
    Replies: 5
    Last Post: 11-05-2020, 11:01 PM
  5. Replies: 1
    Last Post: 04-20-2020, 10:08 PM
  6. [SOLVED] CONCATENATEX formula
    By Yaghoub61 in forum Excel General
    Replies: 3
    Last Post: 03-26-2020, 08:16 AM
  7. Replies: 2
    Last Post: 04-22-2016, 05: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