sajil pulath
New Member
Members
Forum Posts: 2
Member Since:
April 2, 2018
April 2, 2018
Offline
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.
Catalin Bombea
Iasi, Romania
Member
Dashboards
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
Forum Posts: 1944
Member Since:
November 8, 2013
November 8, 2013
Offline
Hi Sajil,
To compare different periods, you have to build a different structure, see this example: https://www.daxpatterns.com/co.....e-periods/
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 7
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1944
SunnyKow: 1432
Anders Sehlstedt: 956
Purfleet: 415
Hans Hallebeek: 377
Frans Visser: 351
David_Ng: 318
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Tiago Braga
Rehan Baig
Fred HORVATH
Silke Schmidt
Stuart Barr
Amelia Nolte
David Wier
T P Collins
Gerry Khoo
Jessica
Forum Stats:
Groups: 3
Forums: 25
Topics: 7149
Posts: 31372
Member Stats:
Guest Posters: 50
Members: 34653
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —