Forum Discussion
Latest Status
Hi ALL We need to show the membership status on the selected transaction date for each user. In another fact table, we have the membership status for specific date ranges and sequences. Finally, ...
Anonymous , Create a new column in table 1
New =
var _max =maxx(filter(Table2, Table1[user_id] = Table2[user_id] && Table1[Transaction Date] >= Table2[Start Date]
&& Table1[Transaction Date] <= Table2[End Date]) , Table2[Status])
return
coalesce(_max, "Inactive")
Anonymous , Create a new column in table 1
New =
var _max =maxx(filter(Table2, Table1[user_id] = Table2[user_id] && Table1[Transaction Date] >= Table2[Start Date]
&& Table1[Transaction Date] <= Table2[End Date]) , Table2[Status])
return
coalesce(_max, "Inactive")
Hi amitchandak
Will it work For Sequence wise also?