VBABEGINER
Well-known Member
- Joined
- Jun 15, 2011
- Messages
- 1,229
Hi Team,
Can anyone give me solution on below DAX formula..
Error - Expressions that yield variant data-type cannot be used to define calculated columns
Can anyone give me solution on below DAX formula..
Error - Expressions that yield variant data-type cannot be used to define calculated columns
Column 2 = IF('For PwerBi'[CTT]="MR" && INT(24*'For PwerBi'[TAT_Holiday])>8,">8Hrs",
IF('For PwerBi'[CTT]="MR" && INT(24*'For PwerBi'[TAT_Holiday])<=8,INT(24*'For PwerBi'[TAT_Holiday]),
IF('For PwerBi'[CTT]="MRR" && 'For PwerBi'[TAT_Holiday]<TIMEVALUE("00:30:00"),"<30Min",
IF('For PwerBi'[CTT]="MRR" && 'For PwerBi'[TAT_Holiday]>=TIMEVALUE("00:30:00") && 'For PwerBi'[TAT_Holiday]<TIMEVALUE("01:00:00"),"30 Min - 1 Hr",
IF('For PwerBi'[CTT]="MRR" && 'For PwerBi'[TAT_Holiday]>=TIMEVALUE("01:00:00") && 'For PwerBi'[TAT_Holiday]<TIMEVALUE("01:30:00"),"1 Hr - 1.5 Hr",
IF('For PwerBi'[CTT]="MRR" && 'For PwerBi'[TAT_Holiday]>=TIMEVALUE("01:30:00") && 'For PwerBi'[TAT_Holiday]<TIMEVALUE("02:00:00"),"1.5 Hr - 2 Hr",
IF('For PwerBi'[CTT]="MRR" && 'For PwerBi'[TAT_Holiday]>=TIMEVALUE("02:00:00") && 'For PwerBi'[TAT_Holiday]<TIMEVALUE("02:30:00"),"2 Hr - 2.5 Hr",
IF('For PwerBi'[CTT]="MRR" && 'For PwerBi'[TAT_Holiday]>=TIMEVALUE("02:30:00") && 'For PwerBi'[TAT_Holiday]<TIMEVALUE("03:00:00"),"2.5 Hr - 3 Hr",
IF('For PwerBi'[CTT]="MRR" && 'For PwerBi'[TAT_Holiday]>=TIMEVALUE("03:00:00") && 'For PwerBi'[TAT_Holiday]<TIMEVALUE("03:30:00"),"3 Hr - 3.5 Hr",
IF('For PwerBi'[CTT]="MRR" && 'For PwerBi'[TAT_Holiday]>=TIMEVALUE("03:30:00") && 'For PwerBi'[TAT_Holiday]<TIMEVALUE("04:00:00"),"3.5 Hr - 4 Hr",
IF('For PwerBi'[CTT]="MRR" && 'For PwerBi'[TAT_Holiday]>=TIMEVALUE("04:00:00"),"> 4 Hr",
IF('For PwerBi'[CTT]="RNW" && INT(24*'For PwerBi'[TAT_Holiday])<8,"< 8 Hrs",
IF('For PwerBi'[CTT]="RNW" && INT(24*'For PwerBi'[TAT_Holiday])>=8 && INT(24*'For PwerBi'[TAT_Holiday])<16,"8 - 16 hrs",
IF('For PwerBi'[CTT]="RNW" && INT(24*'For PwerBi'[TAT_Holiday])>=16 && INT(24*'For PwerBi'[TAT_Holiday])<24,"16 - 24 hrs",
IF('For PwerBi'[CTT]="RNW" && INT(24*'For PwerBi'[TAT_Holiday])>=24 && INT(24*'For PwerBi'[TAT_Holiday])<36,"24 hrs - 36 hrs",
IF('For PwerBi'[CTT]="RNW" && INT(24*'For PwerBi'[TAT_Holiday])>=36 && INT(24*'For PwerBi'[TAT_Holiday]),"36 hrs - 48 hrs",
IF('For PwerBi'[CTT]="RNW" && INT(24*'For PwerBi'[TAT_Holiday])>=48,"> 48 hrs",
IF('For PwerBi'[CTT]="NA","NA",INT(24*'For PwerBi'[TAT_Holiday])))))))))))))))))))