Return Column Name of Last Non-zero value in row range
Hi all - I am attempting to recreate a formulated column I have in excel to DAX language. I have had a lot of luck googling other power bi queries, but I can't find anything on this. I am using the lookup function in excel, but i can't find the equivalent in DAX. Dax has a "lookupvalue" fuction but this does not seem to work the same. The custom column needs to be populated by the "column name" corresponding to the last "non-zero" value in a row. Example is below of the excel version of the formula. Does anyone know how to make this same calculation with a custom DAX column in Power BI? =LOOKUP(2,1/(Table1[@[FY2021]:[FY2031]]<>0),RIGHT(Table1[[#Headers],[FY2021]:[FY2031]],4))
