Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
77
Views
Topic starter
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.
Posted : 21/10/2021 10:03 am
Hi Sajil,
To compare different periods, you have to build a different structure, see this example: https://www.daxpatterns.com/comparing-different-time-periods/
Posted : 30/10/2021 12:53 am