TRIMMEAN

When you think you pick an easy one... In my recent quest to create or catalog as many DAX equivalents for Excel functions, I figured this one would be a cinch. Well, not so much. Between poor ...

TRIMMEAN.pbix124 KB

Mathematical

Other

Totals

Anonymous

Not applicable

5 years ago

Hi Greg! I'm looking to just trim off the top and bottom 10% of a calculated column. This seems like it's doing a lot more than that. Is there a simpler solution, please? Thank you!

Greg_Deckler

Community Champion

5 years ago

Anonymous Nope, that's exactly what this calculation is doing if you set the __Percent variable to .1.

Sorry, TRIMMEAN is one nasty function in DAX...

This thread has some good stuff from ImkeF: Solved: Replicating TRIMMEAN in DAX - Microsoft Power BI Community

Anonymous
Not applicable
5 years ago
Thank you for your response! I'll give it a shot. What do you recommend if I would need further assistance?
- Greg_Deckler
  Community Champion
  5 years ago
  Anonymous Just shoot me a note. I designed the formula so that the only thing you should have to mess with is the __Table variable and the __Percent variable. In theory...
  - Anonymous
    Not applicable
    5 years ago
    Hi Greg,
    
    Thank you! I plugged in your formula and I'm getting closer! However, getting an error related to Column cannot be found or may not be used in this expression. It's on "CumulativeTopCount," "CumulativeBottomCount" and "Value." I have looked up the error, but don't see anything awry. Any ideas, please? Thanks again!