Forum Discussion
Helper IIVisualizing Historical Data
Hi tom-lenzmeier ,
In my example, I used the IsCurrent flag in the table to determine the version. I added a column where IsCurrent = 1 is labeled as Version 1 (current record), and IsCurrent = 0 as Version 0 (historical record).
I also transformed the data in Power Query by unpivoting columns like StartDate, EndDate, CurrentPrice, and PriceValidFrom, so these attributes are displayed as rows.
For the matrix visual, I set:
Rows: Attributes
Columns: Version
Values: AttributeValue
I disabled row and column subtotals so only the values appear side by side in the matrix.
Since your table already uses the SCD Type 2 structure (StartDate, EndDate, IsCurrent) as described in the documentation, this approach should work for you as well.
If you need more details, just let me know.
Community SupportHi tom-lenzmeier ,
As Ashish_Mathur mentioned earlier, an example dataset would help demonstrate the versioned matrix approach more clearly. If you could share a few sample rows from your table and what the expected result should look like, it will be easier for the community to suggest the best way to structure the matrix and filtering logic.
Regards,
Yugandhar.