DAX

[Anonymous]

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

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)

Thank you!

[amitchandak]

@Anonymous , Try like

calculate( maxx(filter(Table , [Fund Source] IN {"I","Institution Aid"} && [Fund Type] IN {"G","Grant","Scholarship"}), [Award Amount] ,blank())
, allexcept(Table, Table[Student Id][Academic Period Id],[Fund Name]))

My suggestion would, you share some sample data and expected output. We may achieve things better in power bi in different manner

refer: https://medium.com/@amitchandak/migrating-from-tableau-to-power-bi-15a51b632e91