Count number of occurrences

[indapines]

Hi All!

Currently trying to implement a measure that would give me a count of occurrences of sales(count), for a specific customer, and specific product, that occurs within 5 days of difference. Is this possible to implement?

So, basically, we have 4 columns - Sale Number, Product, Customer, Date of sale.

Thanks

[FreemanZ]

hi @indapines 

try like

Measure =

COUNTX(

    SUMMARIZE(

        TableName,

        TableName[Product],

        TableName[Customer]

    ),

    TableName[Sale Number]

)