April 2, 2018
Hello Mates, I was trying to create a recon statement by using PowerPivot.. I have to find the difference b/w two data per Account Number and compare the difference b/w two months. I have a large number of rows, where there are no difference or difference is constant. So, I am looking for to add a Filter based on the change in difference amount b/w two months. I have attached a sample work along with steps done so far, you can modify the steps if required. Appreciated your support.
November 8, 2013
To compare different periods, you have to build a different structure, see this example: https://www.daxpatterns.com/co.....e-periods/