Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 end (1 product in two different promotions with the same end date I I only count it 1 time), so in the example of the image I would only count the product "1" once, even though it is in two different promotions, what matters is whether the end date is the same or not. Any doubts I make myself available, thank you
Solved! Go to Solution.
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:
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.
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:
Here it ended up going wrong, I believe it may be related to the fact that my "Product" is in another table, I have a product table linked to the promotion table
Hey @Vitor_sp_bo ,
can you give an example how your data looks?
And when you reply please link my username with an @ symbol. Otherwise I will not be notified that you replied.
Best regards
Denis
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |