Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=if(not isnull(prj_number) and len(prj_number)>1,prj_Status,
if(((not IsNull(dmnd_number)) and len(dmnd_number)>1) or (isnull(prj_number) and (len(prj_number)<1)),dmnd_status,
if(not isnull (idea_status),idea_status)))
while i am giving this as measure i could see prj_status and dmnd_status but i could not see idea status its showing null
I recommend you do it on load script creating a new dimension for this purpose.
ually these three fields are coming from three different table and if i join these tables it is giving me error .not sure what approach can be used here