Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

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 ...
Mathematical
Other
Totals
Anonymous's avatar
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!

    • Anonymous's avatar
      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's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity 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...