Period Over Period Change Help

Hi matthew_hampton,

Based on your table structure, I guess you use two column to mapping unique date records, right?

If this is a case, current power bi not support active multiple relationship columns between two related tables at same time.

For your scenario, time intelligence function can't correct mapping accurate date range which stored in calendar table.

So it return blank and got the correct records when you fix relationships.

Reference link:

How to fix #dax time intelligence functions in #powerbi when date table uses a surrogate key

In my opinion, I'd like to suggest you merge account number and period columns to one and do same operation on calendar table side, then use new column as the relationship column and try again.

If above not help, please share more detailed information to help us clarify your situation.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng