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

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.

Reply
Anonymous
Not applicable

Count duplicates in rolling quarter from date slicer

UPDATED

pbiuser001_0-1663720369324.png


I think I need sommething like count duplicates value by trade
Within 3 month period (from start date month and including 2 months back to get a 3 month rolling period)

And then to make it more difficult when someone selects a month here:

pbiuser001_1-1663720368912.png

 

I would like it to filter the table above to show the 3 month period (current month and prev 2 months)

1 ACCEPTED SOLUTION
Whitewater100
Solution Sage
Solution Sage

Hi pbiuser001:

 

Please see attached file for solution. I hope this helps! 
*I included A as a duplicate, following the logic in your image above.
https://drive.google.com/file/d/1XSa8uyOsQ5G1yFbiliJufm3tvZfjLyW2/view?usp=sharinghttps://drive.google.com/file/d/1XSa8uyOsQ5G1yFbiliJufm3tvZfjLyW2/view?usp=sharing 

Whitewater100_0-1663771483288.png

 




View solution in original post

3 REPLIES 3
Whitewater100
Solution Sage
Solution Sage

Hi pbiuser001:

 

Please see attached file for solution. I hope this helps! 
*I included A as a duplicate, following the logic in your image above.
https://drive.google.com/file/d/1XSa8uyOsQ5G1yFbiliJufm3tvZfjLyW2/view?usp=sharinghttps://drive.google.com/file/d/1XSa8uyOsQ5G1yFbiliJufm3tvZfjLyW2/view?usp=sharing 

Whitewater100_0-1663771483288.png

 




tamerj1
Super User
Super User

Hi @Anonymous 
Would you please paste a screenshot of the visual?

Anonymous
Not applicable

Hi @tamerj1  I think I can provide something that will help without sharing too much private data.

pbiuser001_2-1663718711343.png

 

 


I think I need sommething like count duplicates value by trade
Within 3 month period (from start date month and including 2 months back to get a 3 month rolling period)

And then to make it more difficult when someone selects a month here:

pbiuser001_3-1663718885304.png

I would like it to filter the table above to show the 3 month period (current month and prev 2 months)

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors