Forum Discussion

Vitalie_C's avatar
Vitalie_C
Copper Contributor
Feb 22, 2024

PIVOT Table, MAX formula

Hello Team,  I am seeking some help and a solution to my issue. If it was already covered, kindly point it out to me. Thank you. Example of the report on the link: File  Link with the screenshot: ...
Excel
Formulas and Functions
Lorenzo's avatar
Lorenzo
Silver Contributor

Hello Vitalie_C 

 

With Power Pivot (assuming you run Excel / Windows):

 

A few intermediate Measures are not visible in the Pivot fields but are in the Model

Vitalie_C's avatar
Vitalie_C
Copper Contributor
Feb 23, 2024
Hi Lorenzo, i see that i works as requested, thank you ! Can you help me with the steps too?

Thank you
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Feb 24, 2024

    Hi Vitalie_C 

     

    Can you help me with the steps too?

    What do you exactly mean/wants (currently away - don't expect timely reply)