Forum Discussion
Use Measure to create Calculated Column
- 1 year ago
Hello privledged_test
try this DAX for column
MiscLineColumn =
VAR CurrentOrder = '2025'[Order]
VAR CurrentLine = '2025'[Line#]
VAR FirstLine =
CALCULATE(
MIN('2025'[Line#]),
FILTER(
'2025',
'2025'[Order] = CurrentOrder
)
)
VAR MiscValue =
CALCULATE(
MAX('2025'[value.OrderHed_DocTotalMisc]),
FILTER(
'2025',
'2025'[Order] = CurrentOrder
)
)
RETURN
IF(CurrentLine = FirstLine, MiscValue, 0)
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Hello privledged_test
try this DAX for column
MiscLineColumn =
VAR CurrentOrder = '2025'[Order]
VAR CurrentLine = '2025'[Line#]
VAR FirstLine =
CALCULATE(
MIN('2025'[Line#]),
FILTER(
'2025',
'2025'[Order] = CurrentOrder
)
)
VAR MiscValue =
CALCULATE(
MAX('2025'[value.OrderHed_DocTotalMisc]),
FILTER(
'2025',
'2025'[Order] = CurrentOrder
)
)
RETURN
IF(CurrentLine = FirstLine, MiscValue, 0)
Thanks,
Pankaj Namekar | LinkedIn
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.