Forum Discussion
Replacing blanks with value based on ID
Hey I'm trying to replace the blanks in the subtotal column with the subtotal amount that corresponds to the Order ID. I made a mock table of it here My goal is this
Oh, I see now you used my column name as part of the code.
You need to remove my name or the original column name.
Anyway you can PM me and we'll do it together in zoom
SpartaBI
Community Champion
Community ChampionAnonymous create this calculated column:
'Table'[Subtotal] =
VAR _current_id = 'Table'[Order ID]
VAR _result =
SUMX(
FILTER(
'Table',
'Table'[Order ID] = _current_id
),
'Table'[Price]
)
RETURN
_result