Forum

Add a Remark as a m...
 
Notifications
Clear all

Add a Remark as a measure to filter the PowerPivot Table

2 Posts
2 Users
0 Reactions
77 Views
(@sajil)
Posts: 2
Active Member
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
(@catalinb)
Posts: 1937
Member Admin
 

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
Share: