Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX calculations

Hi, Please help me to convert the following Tableau calculation in DAX.

IF { FIXED [Student Id]:SUM(IF CONTAINS([XYZ],'FGEN') THEN 1 ELSE 0 END)} > 0 THEN 'First Gen' ELSE 'Non-First Gen' END

IF { FIXED [Student Id]:SUM(IF UPPER([Fund Name]) = 'GRANT' THEN 1 ELSE 0 END)} > 0 THEN 'Grant' ELSE 'No Grant' END

{ FIXED [Student Id]:MAX(IF [Academic Period Id] = { FIXED [Student Id]:MAX([Academic Period Id])} THEN [Credits Earned] END)}

IFNULL({ FIXED [Student Id],[Academic Period Id],[Fund Name]:MAX(IF [Fund Source] IN ('I','Institution Aid') AND [Fund Type] IN ('G','Grant','Scholarship') THEN [Award Amount] END)},0)

IF IFNULL([Need Fm],0) < IFNULL([Need Im],0) THEN IFNULL([Need Fm],0) ELSE IFNULL([Need Im],0) END

Thank you!