Forum Discussion

rodrigoestrella's avatar
rodrigoestrella
Frequent Visitor
8 years ago
Solved

Min/Max column Chart

Hello everyone! I need to make a measure that shows me the day of maximum average clients for each store. In a table I have the clients for each day of the month for each store. And I need to make ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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

  • Anonymous's avatar
    Anonymous
    8 years ago

    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]))

     

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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

  • rodrigoestrella's avatar
    rodrigoestrella
    Frequent Visitor
    8 years ago

    Sure Dale, thanks for replying 

    StoreKeyDateClientsArticlesTicket Timeart. per minuteOpen Box TimeSales 
    2201711011774209452932,136,444069,4641205,26 
    3201711014603458487,256,16838,1585529,63 
    42017110176468481023,385,871449,67206713,44 
    5201711014611,280,5217,175926 
    62017110165967551053,15,811445,33200290,93 
    720171101930129021841,426,412479,7412736,77 
    8201711015326599859,076,931290,1196952,02 
    920171101826122151589,727,072145,53419640,5 
    10201711016966699855,376,91204,83163472,46 
    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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]))