Forum Discussion

lang22's avatar
lang22
Frequent Visitor
2 years ago

Rewrite Tableau to DAX

Any help yall can provide when rewriting this Tableau Calc Column to DAX is appreciated. I have been struggling using Switch(True() and combinations of && ||   IFNULL(IF ([Column1] = 1 OR [Column2]...
Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi, lang22 

 

not sure but try below code for new column

IF( 
	[c1]=1||[c2]=1,
	IF(
	[c3]=1||[c4]=1||[c5]=1||[c6]=1||[c7]=1,
	IF(
	[c8]=0,"A&c",if(
                [c1]=1||[c2]=1,IF([c3]=0 &&[c4]=0&& [c5]=0 &&[c6]=0 && [c7]=0&&[c8]=0,"A only"),
		    if([c1]=0||[c2]=0,IF([c3]=1||[c4]=1||[c5]=1||[c6]=1||[c7]=1&&[c8]=0,"C only",IF([c8]=1,"Nian")))))))

 

here just repale c with column in your code

lang22's avatar
lang22
Frequent Visitor
2 years ago

Why is Switch and True not something you are using? It's not a requirement ovbiously, just curious