Forum Discussion
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!
1 Reply
- amitchandak
Super User
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