Calculated column doesn't show data.

[RashmiRGowda]

I have created a calculated column with the below DAX, it doesn't show error but not showing data.

TimeCategory =
IF (
'Onyx Data -DataDNA Dataset Chal'[Time (bins)] = TIME (00,00,00),
"Midnight",
IF (
'Onyx Data -DataDNA Dataset Chal'[Time (bins)] = TIME (04,00,00),
"EarlyMorning",
IF (
'Onyx Data -DataDNA Dataset Chal'[Time (bins)] = TIME (08,00,00),
"Morning",
IF (
'Onyx Data -DataDNA Dataset Chal'[Time (bins)] = TIME (12,00,00),
"Noon",
IF (
'Onyx Data -DataDNA Dataset Chal'[Time (bins)] = TIME (16,00,00),
"Evening",
IF (
'Onyx Data -DataDNA Dataset Chal'[Time (bins)] = TIME (20,00,00),
"Night"
)
)
)
)
)
)

[Greg_Deckler]

@RashmiRGowda Verify that your Time (bins) column is set to a Time data type and not anything else. Also, I would use SWITCH instead of nested IF statements. I created a mock-up of this and was able to get your code to work just fine. Could potentially try something like:

Column = 
SWITCH( TRUE(),
  'Onyx Data -DataDNA Dataset Chal'[Time (bins)] < TIME (04,00,00), "Midnight",
  'Onyx Data -DataDNA Dataset Chal'[Time (bins)] < TIME (08,00,00), "EarlyMorning",
  'Onyx Data -DataDNA Dataset Chal'[Time (bins)] < TIME (12,00,00), "Morning",
  'Onyx Data -DataDNA Dataset Chal'[Time (bins)] < TIME (16,00,00), "Noon",
  'Onyx Data -DataDNA Dataset Chal'[Time (bins)] < TIME (20,00,00), "Evening",
  "Night"
)

PBIX is attached below signature.

[CoreyP]

Try using a switch statement...eg)

TimeCategory = 
SWITCH( TRUE() , 
[TImeBins] = TIME( 12, 00, 00 ) , "Noon" ,
[TImeBins] = TIME( 00, 00, 00 ) , "Midnight" ,
etc... ,
BLANK()
)