Forum Discussion
Yumikang
Helper II
Helper IIWhy does my VAR function return other values for newly created columns?
Dear all, I need help,Why does my VAR function return other values for newly created columns? I would like to create new columns about entry times as shown in the green box. Find the latest entry ...
pls try this and add the similar coding in red in your original DAX.
Column =VAR _last=maxx(FILTER('Table','Table'[number]=EARLIER('Table'[number])&&'Table'[entry time]<EARLIER('Table'[entry time])),'Table'[entry time])return if (ISBLANK(_last),'Table'[entry time],_last)
ryan_mayu
Super User
Super Userpls try this and add the similar coding in red in your original DAX.
Column =
VAR _last=maxx(FILTER('Table','Table'[number]=EARLIER('Table'[number])&&'Table'[entry time]<EARLIER('Table'[entry time])),'Table'[entry time])
return if (ISBLANK(_last),'Table'[entry time],_last)