• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    Remove duplicates from a single cell and concatenate a row?

    Why can't you use if statements? Do you have to use VBA? =IF(COUNTIF($A$1:A1,A1)=1,A1,"")&IF(COUNTIF($A$1:A2,A2)=1,","&A2,"")&IF(COUNTIF($A$1:A3,A3)=1,","&A3,"")&IF(COUNTIF($A$1:A4,A4)=1,","&A4, "")&IF(COUNTIF($A$5:A5,A5)=1,","&A5,"")&IF(COUNTIF($A$1:A6,A6)=1,","&A6,"")
  2. J

    PowerPivot: How can I address individual cells or ranges within DAX measure

    Chandoo, Thanks! I'll give that a try.
  3. J

    Pivot table from data of same kind coming from two different sheets

    It may be overkill (for small data sets, I'd copy and paste tables together), but you can create a second file and create a data connection to your original file. Then use PowerPivot to create a connection to the table. You can then edit the PowerPivot link and combine your two tables into one...
  4. J

    PowerPivot: How can I address individual cells or ranges within DAX measure

    Has anyone figured out how to get DAX to access cells or named ranges? The PowerPivot FAQ says "Unlike Excel formulas, DAX has no notion of addressing individual cells or ranges". I'm hoping there is a way around this. Specifically, I'm trying to use a calculated date form cell (A5) and use...
Back
Top