Hi,
I have the data of an app that offers several products at the same time:
- Digital Wallet
- Taxi
- Bus
- Bike
The app registers each users data in a separate table which has the necessary key value to recognize the user in any of the 4 tables mentioned above.
I created a calculated column for each of those 4 tables that looks for the last date of the last transaction of each user and calculates the date difference between that date and today.
So, for each user we have the amount of days since last transaction. And I pull that to the users table in order to start creating a user profile. Now, the problem;
I need a measure or calculated column that calculates the 4 date differences I created based on the month. So, right now I have the current values, I need to calculate this date differences for each month.
Ex: For November: set a MAX for November 30th and calculate de last date of every user in each of the 4 tables
anyone can help?
