Displaying Latest Value in a table using data from Direct Query

[honormurison]

I am trying to create a table which shows the latest status of a process in the form;

Process   |   Last Updated   |   Status

At the moment it is showing me the Last Update of each Process for each Status rather than just the current one of that Process. I have tried so filter by the relevant date like this;

Latest Update = SWITCH(

    MAXX('AI Opps',[Modified On].[Date]),  [Modified On].[Date], "Y","N" )

But because the data is from direct query this operation is not allowed. 

Is tehre ny way of achieving this with data from direct query?

[v-yuta-msft]

Hi honormurison,

Could you share some sample data and clarify more details about your expected result?

Regards,

Jimmy Tao