Showing results for 
Search instead for 
Did you mean: 
HelloPowerBi Frequent Visitor
Frequent Visitor

Prior year sales by store

Hi guys,


I am trying to find out prior year sales by stores.


I have a 2017 and 2018 data tables by daily sales. If a store was closed in 2017, there will be no data in 2018. 


I have also created a master list store table which is able to pull current week sales and prior year 2017 sales. But the problem is that if the store was closed in 2017, there will be no sales reflected in current year which is correct, but it does not show the prior year sales in 2017. This is incorrect. There should be some sales amount in the prior year sales even though there is no sales in 2018. 


May i know what is the problem here? 





Community Support Team
Community Support Team

Re: Prior year sales by store



You may use UNION Function to add a calculated table first, then add an appropriate measure.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.