The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
5 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
5 | |
4 | |
4 | |
3 | |
2 |