Hi All,
Can we find who is the first customer who purchased the first product in superstore data using LOD?
답변 4개
Hi Shaunak,
You need to create one calculated fields which is as below
{ FIXED [Customer Name],[Product Name]: min([Order Date]) }
Drag and Drop below screenshot dimensions into Rows section.
Write Down Index() into Rows section and Right Click -> select 'Discrete'
Drag and drop above index() into Filters section and select 1 value checkbox.
Your expected output as below.
Let me know if you have any issue.
Please find attached workbook for your reference.
