Home Forums Power Pivot Percentile 80 in DAX 2013

Tagged: 

This topic contains 8 replies, has 2 voices, and was last updated by  tomallan 6 months ago.

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • #9604

    vaz.felipe
    Participant
    • Started: 1
    • Replies: 4
    • Total: 5

    I attached a sort of table and I’d like to calculate percentile 80 to “qtd/cons” for each category in “Col1” as a calculated column.

    Attachments:
    You must be logged in to view attached files.
    #9606

    vaz.felipe
    Participant
    • Started: 1
    • Replies: 4
    • Total: 5

    And this one attached is the expected resuls

    Attachments:
    You must be logged in to view attached files.
    #9609

    tomallan
    Keymaster
    • Started: 7
    • Replies: 2517
    • Total: 2524

    Marco Russo and Alberto Ferrari given an example of a percentile calculation using Excel 2013 which you can read about here.

    #9610

    vaz.felipe
    Participant
    • Started: 1
    • Replies: 4
    • Total: 5

    Hi tomallan

     

    Ive seen this post before. Yeap!

    The question there works for only um category. I have a column not with one category but multiple caregories.

    When I implement that calculation that works fine for all values. When I place my column of categories this summarizing process does not works for that method

    #9611

    tomallan
    Keymaster
    • Started: 7
    • Replies: 2517
    • Total: 2524
    #9612

    vaz.felipe
    Participant
    • Started: 1
    • Replies: 4
    • Total: 5

    Tom, I think this might be a good Cue… Uhuuul

    Im going to try. Thks

     

    #9613

    tomallan
    Keymaster
    • Started: 7
    • Replies: 2517
    • Total: 2524

    Am thinking good thoughts for your success!

    #9614

    vaz.felipe
    Participant
    • Started: 1
    • Replies: 4
    • Total: 5

    TOOOOOOM

    WORKS PERFECTLY

    OMGOODNESSSSSSS

    Thanks for all you support! I was seeking this answeer for at least 20 hours. Thank you!

    If someone wants to see the final archive, see attached.

    Attachments:
    You must be logged in to view attached files.
    #9616

    tomallan
    Keymaster
    • Started: 7
    • Replies: 2517
    • Total: 2524

    Many thanks for the kind words.

    Glad to hear of your success!

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic.