Hi there, I am currently using the following two measures with a power pivot table:
Sales Count
=DISTINCTCOUNT(SalesHistory[Transaction ID])
Sales Frequency (return a “2” if there are at least 3 sales instances, “1” if instances of sales is between 1-3, “0” if no sale)
=if([Sales Count]>=3,2,IF([Sales Count]=0,0,1))
I then use a timeline slicer to set the period for which Sales Frequency is calculated. Instead of the slicer, how can I adapt the measure to calculate this for the preceding 12 months? This would be based on the field SalesHistory[Service Date] ? Thank you.
Sales Count
=DISTINCTCOUNT(SalesHistory[Transaction ID])
Sales Frequency (return a “2” if there are at least 3 sales instances, “1” if instances of sales is between 1-3, “0” if no sale)
=if([Sales Count]>=3,2,IF([Sales Count]=0,0,1))
I then use a timeline slicer to set the period for which Sales Frequency is calculated. Instead of the slicer, how can I adapt the measure to calculate this for the preceding 12 months? This would be based on the field SalesHistory[Service Date] ? Thank you.
