Ratio Analysis

[Yrstruly2021]

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?

https://drive.google.com/file/d/1ztaF0QPrSaqqOQW3OQv-oGCy14j3SFXV/view?usp=sharing 

[Yrstruly2021]

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

[Greg_Deckler]

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

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