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

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...

    • Anonymous's avatar
      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!

       

       

       
      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        5 years ago

        Anonymous Oi! You need to use DAX formatter so that I can decipher what is going on in the formula: https://www.daxformatter.com/

         

        At first blush, you seem to be missing an ADDCOLUMNS in your RankTable calculation. The underlined columns can't be used until the ADDCOLUMNS is finalized, which is the reason for the double ADDCOLUMNS logic in RankTable VAR.