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 Anonymous and thank you for your suggestions. After reading your feedback I tried the column logic you provided and it worked to a certain extent. What it's doing is only returning a 1 or a 0 when it meets the criteria. it will return a 1 if it's greater or = 1, and a 0 if the number from the column is less than or =1. In theory it's returning correctly, but what i am really looking for is what you prescribed which was to return the actual number in the column and a blank if it's outside the criteria (blank if it's not >=1 and the actual data point number if it is >=1). What am i doing wrong?
Below is the formula i used. Thanks in advance
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()
)
Of course! Simple enough. That worked and all my numbers are what i need them to be. THANK YOU!