Forum Discussion
Solved
Column chart help
Hello everyone, I'm making Power BI graphs with data from a Sharepoint list, in which I have customers who are subscribed to a service. The service has a contract start date, and I want to make a...
Based on your description, it sounds like a typical "slow changing dimension" scenario.
It's better to keep all start date into one column, then add "End Date" column, and a "Status" column to tag which entry is Current. For more details, please refer to articles below:
PowerPivot and the Slowly Changing Dimensions
Regards,
v-sihou-msft
Microsoft Employee
Microsoft Employee
Based on your description, it sounds like a typical "slow changing dimension" scenario.
It's better to keep all start date into one column, then add "End Date" column, and a "Status" column to tag which entry is Current. For more details, please refer to articles below:
PowerPivot and the Slowly Changing Dimensions
Regards,