Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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