Forum Discussion
Solved
DAX column that returns values from column when data points are >=1
Hi I'm trying to create a DAX column that returns values from a column when the values are greater or equal to 1. The column it's pulling from has values that range from -350 through 250 and I only ...
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())
