Forum Discussion

Yrstruly2021's avatar
Yrstruly2021
Icon for Helper V rankHelper V
5 years ago

Ratio Analysis

Please assist? What store has the highest percentage decrease in sales between Jul 2019 and Jul 2020 and What region has the highest Sales/clocked hours ratio in 2020 YTD? What was the ratio?     ...
Tutorial Requests
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)