Forum Discussion
Helper IVDAX 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())
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()
)
Helper IVOf course! Simple enough. That worked and all my numbers are what i need them to be. THANK YOU!