Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Thanks
You may use UNION Function to add a calculated table first, then add an appropriate measure.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |