Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have loaded table as below
Order No | Batch No | Customer Name | Date |
1 | 99308 | ABC | 01-04-2022 |
2 | 99292 | ABC | 05-31-2022 |
3 | 99310 | XYZ | 06-19-2022 |
4 | 99018 | XYZ | 06-09-2022 |
4 | 99313 | PQR | 04-02-2022 |
3 | 99310 | UVW | 01-01-2022 |
As seen there are multiple dates for some customer names. I want only the minimum date for Customer ABC (Here 01-04-2022). Tried using Group by, but didn't work since I have calculated measures in my table.
Any help would be appreciated
Regards,
Aditya
Utilize firstsortedvalue to achieve this -
have u tried like
load customername,min(Date) resident test group by customername;
Hi
Try like this for specific customer in back end
load customername,min(Date) resident test
where customername = 'ABC' group by customername;
or, in front end, try like
Min({<customername = {'ABC'}>}Date)