Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hi,
i'm new to this whole DAX thing and need help with a powerbi query
my dat is as follows
A document no. can have multiple account no. i'm tyring to create a new column where the account no fill down to the below blank rows.
Document No line no acct. No. new column
P1000 1000 6100 6100
P1000 2000 6100
P1000 3000 6100
P2000 1000 7000 7000
P2000 2000 8000 7000
P3000 1000 6500 6500
P3000 2000 6500
P3000 3000 6800 8000
P3000 4000 8000
P3000 5000 8000
any help with this would be greatly appreciated.
hi,
i'm new to this whole DAX thing and need help with a powerbi query
my dat is as follows
A document no. can have multiple account no. i'm tyring to create a new column where the account no fill down to the below blank rows.
Document No line no acct. No. new column
P1000 1000 6100 6100
P1000 2000 6100
P1000 3000 6100
P2000 1000 7000 7000
P2000 2000 8000 8000
P3000 1000 6500 6500
P3000 2000 6500
P3000 3000 8000 8000
P3000 4000 8000
P3000 5000 8000
any help with this would be greatly appreciated.
Duplicate question see - http://community.powerbi.com/t5/Desktop/value-from-row-above/m-p/466115#M216424
Searching the forum I found this solution by @Vvelarde
To adapt this to your problme I added an index column to your data in the PowerQuery (Edit Query) using the Add Index button in the add column ribbon. With the index column added this worked!
Fixed Account No =
IF([Account No],[Account No],
CALCULATE(LASTNONBLANK(Table1[Account No],Table1[Account No]),
FILTER(Table1,Table1[Index]<=EARLIER([Index]))
)
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |