Forum Discussion

Vitor_sp_bo's avatar
Vitor_sp_bo
Helper I
4 years ago
Solved

count on date

Guys, good morning! All right ? I need help with a formula that counts how many times a product has been on sale, 1 product can be in more than one promotion, but if the promotion date has the same ...
Need Help
  • selimovd's avatar
    selimovd
    4 years ago

    Hey Vitor_sp_bo ,

     

    you can just summarize the columns by product and promotion end date and then count the rows with a COUNTX.
    Like this products with the same end date will only count once. The following measure should do that:

    Amount Promotions =
COUNTX (
    SUMMARIZE (
        myPromotions,
        myPromotions[Product],
        myPromotions[Promotion end date]
    ),
    1
)

     

    And it also shows the result you want:

     

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, Vitor_sp_bo 

 

The data in the two screenshots above does not match the first one and the data in the screenshot above seems to be incomplete.

Could you please consdier sharing more details about it and posting expected result so it is clear on what needs to be implemented?  And It would be great if there is a sample file without any sesentive information here.

It makes it easier to give you a solution.

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.