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),
"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"
)
)
)
)
)
)

 

 

 

Need Help

2 Replies

  • CoreyP's avatar
    CoreyP
    Solution Sage
    2 years ago

    Try using a switch statement...eg)

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

  • 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.