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,
I want to compare the sales amount of several shops with previous year. All my current year and previous year values are in same table. How to filter the value should calculate only if both the year has same shops? I'm using the below dax, If I use this power BI should not detect the new shops.
Solved! Go to Solution.
I wrote an article about this a few years ago. https://powerpivotpro.com/2015/08/nested-sumx-or-dax-query/
I wrote an article about this a few years ago. https://powerpivotpro.com/2015/08/nested-sumx-or-dax-query/
Thank you so much Matt!! Its really worked out !!
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 |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |