Forum Discussion
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...
Try using a switch statement...eg)
TimeCategory =
SWITCH( TRUE() ,
[TImeBins] = TIME( 12, 00, 00 ) , "Noon" ,
[TImeBins] = TIME( 00, 00, 00 ) , "Midnight" ,
etc... ,
BLANK()
)