Forum Discussion

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Yrstruly2021 Highest store % decrease is NYANGA with a 100% change (no sales in July 2020 but sales in July 2019). 

     

    Highest sales/clocked hours ratio in 2020 YTD is ECAPEL EL CENTRAL at 221.30.

     

     

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Yrstruly2021 Just kidding, here are the measures and attached PBIX below sig.

      Sales July 2020 = SUMX(FILTER('Raw data',YEAR([date])=2020 && MONTH([date])=7),[sales])

Sales July 2019 = SUMX(FILTER('Raw data',YEAR([date])=2019 && MONTH([date])=7),[sales])

% Change = DIVIDE([Sales July 2020] - [Sales July 2019],[Sales July 2019],0)

Sales 2020 YTD = SUMX(FILTER('Raw data',YEAR([date])=2020),[sales])

Hours 2020 YTD = SUMX(FILTER('Raw data',YEAR([date])=2020),[hours_clock])

Ratio = DIVIDE([Sales 2020 YTD],[Hours 2020 YTD],0)
  • Yrstruly2021's avatar
    Yrstruly2021
    Icon for Helper V rankHelper V
    5 years ago

    Thank you. I am curious to know how you started your analysis to get to the answers?