Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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