Forum Discussion
Help building subscription status table
Hi, I'm in need of assitance in regards to building a complete status list on a day to day basis for our subscription model. The dataset contains a single line for each single membership, whi...
I fixed my problem by using the query editor instead.
As an Excle user, I'm almost more at home in the query editor than in the viewer.
Anonymous
The explaination doesn't make things much clear for me. Check if this DAX help.
New Table = ADDCOLUMNS(FILTER(
CROSSJOIN('Table1',CALENDARAUTO()) ,[Date]>=Table1[FIRSTPAYMENT]&&[Date]<= DATE(YEAR(Table1[LASTPAYMENT]),MONTH(Table1[LASTPAYMENT])+1,DAY(Table1[LASTPAYMENT]))),
"SUBSCRIPTIONSTATUS_",IF(Table1[LASTPAYMENT]=[Date],Table1[SUBSCRIPTIONSTATUS],"active")
)I fixed my problem by using the query editor instead.
As an Excle user, I'm almost more at home in the query editor than in the viewer.