Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
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
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
@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
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |