The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I've a set of data as belowand want to do Fill Down on column Qty using DAX based on 2 conditions: Item and Year.
Please refer Desired Result column for the wanted outcome.
Item | Year | Qty | Desired Result |
A | 2019 | ||
A | 2020 | 100 | 100 |
A | 2021 | 100 | |
A | 2022 | 75 | 75 |
A | 2023 | 75 | |
B | 2019 | 65 | 65 |
B | 2020 | 65 | |
B | 2021 | 65 | |
B | 2022 | 80 | 80 |
B | 2023 | 80 | |
C | 2019 | ||
C | 2020 | ||
C | 2021 | 30 | 30 |
C | 2022 | 30 | |
C | 2023 | 20 | 20 |
Thanks.
Regards,
LC
Hi @Tan_LC it was really challenging to create this solution as it is not simple previous row data.
Please create new column with code as below. When I check it with desired result difference is zero.
Did I answer your question? Mark my post as a solution! Kudos Appreciated!
Proud to be a Super User!
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
11 | |
7 |