Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Yulia
Frequent Visitor

How to find intersecting points in a set of periods

Good afternoon. Tell me how to solve this problem in Power BI, or at least the direction of thoughts. There is a large database that will continue to be supplemented, it has 4 or more periods (Feb.19, may.19, Aug.19, Nov. 19, etc.) with point codes, by city, brands, SKU, prices, advertising materials, etc. you need to display intersecting points when selecting (in the slicer) periods. For example, show the number of points for the brand "XX" in the city of "Moscow" that were in the selected periods of February.19 and Nov.19. or the number of intersecting points in the period may-August-November. The client can choose any combination of periods. You can translate periods into dates, but I do not understand what this can give. Tell me how to solve this problem? Perhaps someone had similar cases. Any help, I would be grateful.

4 REPLIES 4
Icey
Community Support
Community Support

Hi @Yulia ,

 

Is this problem solved?


If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.


If not, please let me know.

 


Best Regards
Icey

amitchandak
Super User
Super User

What to you meant  by "number of intersecting points"

 

Two you won't compare two ranges and can have any months?

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Tell me how to solve this problem. You need a measure (or perhaps a calculated column) that counts the number of intersecting "point codes" depending on the selected periods. Select periods using the slicer. For example, you selected 3 periods "Aug-Dec-may", count the number of "point codes" that were in all three periods. Test example in the attachment

Intersecting points 

Icey
Community Support
Community Support

Hi @Yulia ,

 

Is "46" the count value you want?

count.PNG

 

If it is, just create a measure like so:

Count = COUNTROWS(Tabl1)

And then, create a Card visual.

 

If not, please show me more details to help me know what you want.

 

 

Best Regards,
Icey

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.