Forum Discussion
Replacing (Blanks) with 0
Dear All, For a production report I'm presenting production numbers based on hours. In some situations the machine did not produce any parts so there is no value for that hour. Is there a fu...
The solution didn't work.
I did solve it by creating a new measure:HourlyCount = var HourlyCounter = CALCULATE(SUM(CounterTable[Value]))
return IF(ISBLANK(HourlyCounter), 0, HourlyCounter)
Hello Anonymous,
you can create new column in DAX with simple formula:
"New Shift Time = IF(Shift[Column] = "", "0", Shift[Column])"
That should do :smileywink:
It turned out like:
HourlyCount = var HourlyCounter = CALCULATE(SUM(CounterTable[Value]))
return IF(ISBLANK(HourlyCounter), 0, HourlyCounter)