Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Table Variable

Hi there,   I have a simplified data model with three tables.   1. account --------- ======= 2. opp( closedate dd/mm/yyyy) ---------- =========== 3. and a date table Calenda...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous ,

 

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

 

Regards,
Frank

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Frank,

 

Thanks for your reply and the follow-up. I just got another question, kindly take a look at the expression below.

If the account table is used inside COUNTROWS instead of k, I can also get the correct result. As I read it from the some other posts, the original table has nothing to do with the table generated by ADDCOLUMNS. Is that true? If so, why the account table can be filtered?

 

RETURN
CALCULATE( COUNTROWS(account),
		FILTER( k,
			[date]>= MIN( 'Calendar'[Date])
			&& [date] <= MAX('Calendar'[Date])))