Forum Discussion
Helper ICalculating Recency with Auto-Updating Sales Data
Super UserHere's how a sample approach for recency for a single customer.
Helper IHi lbendlin ,
Thank you for your suggestions! I tried both the Ribbon chart and the Sankey chart while attempting to avoid creating a calculated table with every combination month-customer_id because I believe that in the long run, it could significantly slow down the system.
Since the Sales file updates over time, the combinations of month and customer_id could become extremely large.
Is there a way to achieve the same goal without slowing down the system and ensuring everything is automatic?
- Is there a way to create the calendar with all month-customer_id combinations directly with a calculated measure and then use these data to create the visual?
- Is there a way to ensure that the table created with the measure and the visual update automatically over time?
Thank you again for your help!
- lbendlin
Is there a way to create the calendar with all month-customer_id combinations directly with a calculated measure and then use these data to create the visual?Measures return scalar values. They cannot hold tables.
Is there a way to ensure that the table created with the measure and the visual update automatically over time?Not sure what you are asking. Assuming your data source is in Import mode this will be taken care of during the semantic model refresh.