Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sales:
LOAD [Order Number],
Product,
Year
FROM
test.xlsx
(ooxml, embedded labels, table is Sheet1);
i want to see how many Order Number is there .
i am using Count (Order Number) in expressions it shows 5 . actually i want to see the result as 3 because 100 is 3 times with different product. what should i do ?
Hi,
try using DISTINCT inside your Count function to count only distinct values. In this example: Count (Distinct [Order Number])
Did you try:
= Count(DISTINCT [Order Number])
Thanks