Forum Discussion

lasmithfla's avatar
lasmithfla
Helper I
4 years ago
Solved

Need help pulling Max date based on a measure

I don't know how to attach the sample powerbi file that I made up for this example; I can't post real data.   I'm able to identify the max sales but need to be able to also extract the date of the ...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI lasmithfla,

    You can try to use summarize and max functions to achieve your requirement:

    MaxSales =
VAR summary =
    SUMMARIZE (
        ALLSELECTED ( SalesTable ),
        [Date],
        "Total", SUM ( SalesTable[TotalSales] )
    )
RETURN
    MAXX ( FILTER ( summary, [Total] = MAXX ( summary, [Total] ) ), [Date] )

    Regards,

    Xiaoxin Sheng

HotChilli's avatar
HotChilli
Community Champion
4 years ago

I think that the MaxSales measure looks a bit overcomplicated.

--

Try putting date and TotalSales measure in a table visual.  Create a ranking measure similar to this:

MeasureRank = 
RANKX(ALL(SalesTable[Date]), [TotalSales])

and put the MeasureRank in a visual filter and set it to 1.

For simple visuals like this, a measure filter can work.

---

If you post your data as text next time, you'll get a faster answer.