Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Hi honormurison,
Could you share some sample data and clarify more details about your expected result?
Regards,
Jimmy Tao
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |