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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Aknas
Frequent Visitor

Filter last three months and create buckets

Hi All,

I'm trying to filter the data only for the last three months by group (ignoring blanks) and create buckets.

I can create the buckets via calculated columns but having difficulties filtering the last three months.

 

Please see if you can be of help. 

 

Here is the sample dataset:

https://1drv.ms/u/s!Arm2JbpOh1VdgSiifpiS5mrrtpwf?e=OCdG2F

 

Here is my desired result:

result.gif

 

Also tried the rolling three months :

rolling 3 months = calculate(COUNTROWS('data'),DATES BETWEEN('Calendar'[Date],EDATE(MIN('Calendar'[Date]),-3),Max('Calendar'[Date]))

 

Thanks

Dii

 

 

 

2 REPLIES 2
Aknas
Frequent Visitor

Thanks Amit.

I can get the buckets - but my issue was how to get count by employee Id for each buckets using avg balance and  bonus for the last 3- month.

 

I tried but still getting error.

 

https://1drv.ms/u/s!Arm2JbpOh1VdgSkmCu3DA3QOm8N6?e=ewERb4

 

Thanks again

amitchandak
Super User
Super User

@Aknas , I think you need Dynamic segmentation, refer these examples

 

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...


Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY

 

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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