DAX calculations

[Anonymous]

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!

[amitchandak]

@Anonymous , refer to the solution I suggested on your another query, if that can help

https://community.powerbi.com/t5/Desktop/LOD-calculation-in-DAX/m-p/2595867#M915319

refer LOD- FIXED (Level of Details): https://youtu.be/hU-cVOwDCvY

Tableau Vs Power BI: https://www.youtube.com/watch?v=tAmg00Wf_cw&list=PLPaNVDMhUXGYzjFASXjdY7GNoFxvlkR54