Forum Discussion
DAX column that returns values from column when data points are >=1
It looks it has to do with your column name where the operator >= 1 is interfering with the DAX [Days Late by BU >= 1]. Can you try changing it by either removing ">= 1" operator or replacing the spaces with underscores?
e.g. [Days_Late_by_BU_>=_1] or simply
[One or more days late] =
if(
NPW[Days Late HR]>=1,
NPW[Days Late HR],
BLANK())
hi ryan_mayu thanks for your suggestion but that isn't what i was looking for. My fault for not providing more details. The response i sent to Anonymous provides what i'm trying to do and where i'm at with his suggestions. Basically trying to create new column that only return data from a different column based on the specific criteria (>=1). From there, i want to take the average of that column which would be my end goal.
