The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
User | Count |
---|---|
86 | |
84 | |
36 | |
34 | |
34 |
User | Count |
---|---|
94 | |
79 | |
65 | |
55 | |
52 |