Forum Discussion
Deriving trends from dynamic data source
Hi all, I have a financial data source showing what each product each active customer purchased. This data refreshes weekly and churned customers disappear from the data, and new customers are added.
I would like to figure out the count of customers over time, as well as who were the new customers in a certain month and which customers churned. I'm thinking maybe I need to archive the data or have some sort of historical data in order to do this. Does anyone know if this is possible in Power BI, and if so, willing to share how?
Hi Anonymous
You might refer to the DAX to set the data collection on a dynamical data source.
https://docs.microsoft.com/en-us/dax/
Also, you can refer to this thread: Storing and using information from a dynamic data source using PBI desktop.
2 Replies
Anonymous there is a great article on this and see if that can help. link is here.
Ask anything Power BI. Book free appointment at https://www.perytus.com
Hi Anonymous
You might refer to the DAX to set the data collection on a dynamical data source.
https://docs.microsoft.com/en-us/dax/
Also, you can refer to this thread: Storing and using information from a dynamic data source using PBI desktop.
