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.
in this problem I need a needed column if seq no is 0 then add a previous value of needed with the value of quantity.. I hope you can understand my problem... If you can't please see the picture there is Excel formula to got understand the problem... Please help me to find out the solution...
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
It is for creating a new column.
needed CC =
VAR _serialno = Data[serial no]
VAR _lastnonzeroseqnoserialno =
MAXX (
FILTER ( Data, Data[serial no] <= _serialno && Data[seq no] <> 0 ),
Data[serial no]
)
RETURN
IF (
Data[seq no] <> 0,
Data[seq no],
MAXX (
FILTER ( Data, Data[serial no] = _lastnonzeroseqnoserialno ),
Data[seq no]
)
+ SUMX (
FILTER (
Data,
Data[serial no] > _lastnonzeroseqnoserialno
&& Data[serial no] <= _serialno
),
Data[quantity]
)
)
Hi,
Please check the below picture and the attached pbix file.
It is for creating a new column.
needed CC =
VAR _serialno = Data[serial no]
VAR _lastnonzeroseqnoserialno =
MAXX (
FILTER ( Data, Data[serial no] <= _serialno && Data[seq no] <> 0 ),
Data[serial no]
)
RETURN
IF (
Data[seq no] <> 0,
Data[seq no],
MAXX (
FILTER ( Data, Data[serial no] = _lastnonzeroseqnoserialno ),
Data[seq no]
)
+ SUMX (
FILTER (
Data,
Data[serial no] > _lastnonzeroseqnoserialno
&& Data[serial no] <= _serialno
),
Data[quantity]
)
)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |