Vander1981
New Member
- Joined
- Jun 20, 2017
- Messages
- 18
Hello Guys,
I would like to ask your help on a DAX problem that I am facing :
I would like to measure the impact of an event on Customers Sales. That event could take place at different time depending of the Customer.
the measure would track sales for a period of 6 months starting from the date of the event (variable for each customers) and compare it to another 6 month period (just before the event).
The problem is that I have no clue at the moment, on how to take into account the date of the event that is stored in my Customer table.
I have a star schema model : Fact table with relationships to different dim tables (Calendar, Customer, Product, geography). I could adapt the model if necessary.
NB : There is no Relationship between Customer table and calendar table.
Thanks a lot for your help
I would like to ask your help on a DAX problem that I am facing :
I would like to measure the impact of an event on Customers Sales. That event could take place at different time depending of the Customer.
the measure would track sales for a period of 6 months starting from the date of the event (variable for each customers) and compare it to another 6 month period (just before the event).
The problem is that I have no clue at the moment, on how to take into account the date of the event that is stored in my Customer table.
I have a star schema model : Fact table with relationships to different dim tables (Calendar, Customer, Product, geography). I could adapt the model if necessary.
NB : There is no Relationship between Customer table and calendar table.
Thanks a lot for your help
