Trouble showing MoM % Change based on non-date table "Date"

[efowler]

Hello, I have multiple issues which I am seeking help with.   I will list them out below and can provide a sample .pbix file if needed.

Desired End Result -->  To show MoM % change based on "Claim Qty".  The MoM should be based on [Warranty,'Claim Date']. and should be able to be filtered based on [Sales,"Sale Date"] & [Warranty,'causal_pt"] & [Warranty,'State"].   Ultimately what I want to do is show the % increase month to month for claims on a specific causal pt from a specific state.  

[v-lionel-msft]

Hi @efowler ,

Month-over-Month | Formula | Examples | eFinanceManagement

How to show monthly values & % changes in one pivot table - Excel Pivot Table Examples (chandoo.org)

Try to refer to these.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[efowler]

Link to sample files - https://app.box.com/s/cnazvlmhc9mu8rg3p4a944038qaujszm