Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a process which runs from a pre-state to a final-state. Commonly this would be modeled with an accumulating snapshot fact table.
Now I am asking wether I build to columns in the fact table, one for pre-state and one for final-state or is is allowed to build just one state column and update the state in place?
Greets
@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |