Forum Discussion

BaldAccountant's avatar
BaldAccountant
Icon for Helper III rankHelper III
3 years ago
Solved

Power Pivot Identify Month with Maximum Amount

I am working in Power Pivot. I have made a sample file https://www.dropbox.com/scl/fi/5z9t0adnmw4pbbbo3czz4/Test-Max-Name.xlsx?dl=0&rlkey=0mg4i5l7ytatj31e7emjadfpf   I made a measure to calculate...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi BaldAccountant 

    please try

    Max Month :=
    MAXX (
    TOPN ( 1, VALUES ( Data[Date (Month)] ), CALCULATE ( COUNT ( Data[Case] ) ) ),
    Data[Date (Month)]
    )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi BaldAccountant 

please try

Max Month :=
MAXX (
TOPN ( 1, VALUES ( Data[Date (Month)] ), CALCULATE ( COUNT ( Data[Case] ) ) ),
Data[Date (Month)]
)

BaldAccountant's avatar
BaldAccountant
Icon for Helper III rankHelper III
3 years ago

tamerj1 That worked, but just in case anyone else has this question and is looking at this thread, your solution was just looking at cases, not the dynamic measure of Analysis Measure, so the only thing you could calculate the max month for was cases.  I substituted that measure for the count(data[case]) and it worked fine.  Thank you very much again.