Forum Discussion
DAX
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!
1 Reply
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
