The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi
I have a simple sharepoint list with a reporting ID ( Integer Type) which tells me the latest reporting period.
The list had multiple reporting IDs, I need to load data with only the latest reporting period.
I know in SQL its easy to do,:
Select * from table
Where ReportingID = (Select Max(RepPeriodID) from table1)
But not sure how to do in Sharepoint lists
Any help will be appreciated.