Forum Discussion
DAX
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 ...
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 !!