How to deal with changes in Power BI dimension tables?
I have a Power BI data model (star schema) with a Dimension customer table and a Fact Sales table. I want to be able to analyse historically which locations had which sales. How would I deal with a customer moving addresses? The product might have been sold to a customer living in Berlin, but now that the customer lives in New York, Berlin has been overridden.
If you are in control of the 'Berlin' being overwritten, the common solution to that problem is to implement whats called a slowly changing dimension. Its described here: https://en.m.wikipedia.org/wiki/Slowly_changing_dimension
The customerId would be a new one, with the change of address, in your case.
If you have no control over the source tables, I dont see a way for you to solve this
HTH Jens
- How do I properly use table.group in a PowerQuery query to dynamically summarize different rows and columns?
- How to create a calculated column that is the sum of values from another table grouped by similar column value?
- How to get all messages post by person in team channels using power apps in teams
- how to change a specific cell in Power Query (M Language)?
- How to Pass a URL Filter to a Power BI Publish to Web Report
- How to create chart in power apps which shows number of post done by team member in teams channel?
- Power BI Folder Connector file ID
- In a datawarehouse can a dimension be related to another dimension?
- Get description from unrelated table with Table 1 ID between Table 2 From ID and To ID in Power BI direct query mode
- Why is my calendar showing years in the future?
- Power BI How to set up data/measure to get averages at two different granularities in a Matrix visualization
- How was the data loaded here with power query?
- How to add a vertical line in a Deneb/VegaLite dumbbell plot
- How do I get y-axis ticks in vega-lite to be "nice" round numbers evenly spaced?
- DAX filter measure based on multiple critera
- How to create drill through using a measure?
- Last day of calendar quarter in Power BI not capped by table column
- Creating Matrix of Counts with Master List
- Creating Dax query for table/matrix visuals
- Power BI Measure Duplicating Rows
- What is the use case of SUM vs SUMX?
- DAX column totals are not giving expected totals when using the MIN
- Power BI Top N filter being ignored
- 2 slicers, same column of same data. Find difference between sliced results
- Remove total value for one column in PowerBI
- DAX: VLOOKUP in IF statement
- How to get error details logs in log analytics workspace for synapse analytics workspace
- Fixed value for a prior year line chart in Power BI
- How to change power BI eraser icon´s color in slicer visual?
- Deneb - Vega require to understand Javascript?