Forum Discussion
Summarize and MAX not functioning as expected
Hi, I have a table that looks like this IDDateGenderSub-District 1 1/8/2019 M A 2 2/8/2019 M A 3 3/8/2019 M B 4 3/8/2019 F B 5 3/8/2019 F B 6 10/8/2019 F ...
Hi Anonymous
For End_Date you are using Table 2 instead of table:
"End_Date", MAX ( 'Table 2'[Date] )
When you SUMMARIZE over ' table', you have no filters applied on Table 2, unless there's a relationship
