Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Report filter automatic result

Hello experts!   I need to filter the report to recognize the most recent date, then filter to only show results for the group of that date. For example...   The most recent event date on the dat...
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Thanks v-caliao-msft

 

When you are referecning the table Latest... for example...

 

LatestDate = CALCULATE(MAX(Latest[DATE]),ALLEXCEPT(Latest,Latest[Event#]))

 

What table are you refering to?  Is it the original table? When I try to create the new column in the original table as you described, its giving me an error.  

 

Sorry for the newbie questions...

 

Paul

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
10 years ago

Hi Pchapple,

 

Yes, create calculated column in the original table. Please share us the error message, so that we can make further analysis.

 

Regards,

Charlie Liao