Forum Discussion

RashmiRGowda's avatar
RashmiRGowda
New Member
2 years ago

Calculated column doesn't show data.

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), "Midnig...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

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.