Min/Max column Chart

Hi rodrigoestrella,

Can you share a dummy sample?

It could be like below.

table =
SUMMARIZE (
    week,
    'clients per day'[sotrekey],
    week[dayname],
    "maxnum", MAX ( week[average of clients] )
)

Best Regards,

Dale

For your data, the orignial type of column Date is number, not the standard DAX datatime format. If you want to get Month and Weekday information from this column, first, you need to use the following DAX to convert the number to datatime.

DateTime = DATE(INT(LEFT(Store[Date],4)),INT(MID(Store[Date],5,2)),INT(RIGHT(Store[Date],2)))

And then create two another calcuated columns to mark the Month and Weekday information

Month = FORMAT(Store[DateTime],"MMMM")

Weekday = FORMAT(Store[DateTime],"DDDD")

After that, you can create a calcuated table and using the following DAX as Dale's suggestion

StoreSummary = SUMMARIZE(Store,Store[StoreKey],Store[Month],Store[WeekDay],"Max",MAX(Store[Clients]))