Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Good day,
I'm new to power bi. I would like to input at "Aging" a specific number and multiply it by % of share for each month:
A Current = 1%
B 1-30 = 2%
C 31-60 = 25%
D 61-90 = 50%
E 91+ = 100%
in example, this will be the data:
Any help will be appreciated. Thank a lot
@mrdiesta , Try something like this using windows function
Power BI ABC Analysis using Window function, Dynamic Segmentation: https://youtu.be/A8mQND2xSR4
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
71 | |
38 | |
29 | |
28 |
User | Count |
---|---|
99 | |
88 | |
62 | |
42 | |
39 |