Forum Discussion
Calculating Recency with Auto-Updating Sales Data
Hi everyone! I need some assistance with a Power BI project related to calculating "Recency" from our sales data. Recency is a metric that measures the number of days since a customer's last purchas...
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.
