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.
Hello Everyone,
I'm trying to find a way to iterative loop through a previous calculation that will be created by a calculated column in DAX. I have to replace an existing .vb application with a PBI report.
This is the .vb code to be replaced:
If f.TCP <> 0D Then ATG = f.MAA - PAC
If ATG > CAAP Then TACC = ATG - CAAP
Else TACC = 0D
End If PAC += TACC
Else TACC = 0D
This is what i have in DAX so far:
My issue seems to be with PAC creating a circular dependency. Many forums online have resources for creating in M however I would like to do it in DAX, if possible. TIA
Try this measure.
PAC =
VAR CurrentRowID = [RowID] -- Assuming you have a unique identifier for each row
VAR PrevPAC =
CALCULATE(
SUM([TACC]),
FILTER(
ALL('YourTable'),
'YourTable'[RowID] < CurrentRowID
)
)
RETURN IF(ISBLANK(PrevPAC), 0, PrevPAC) + [TACC]
@aduguid I do not have one but I can create one. Would it be better to create RowID in M or DAX? Does it matter? Also does it need to be a measure or can it be a calculated column?
I tried as a calculated column and I still get circular dependency error.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |