topic I HAVE 2 DATE FUNCTION IN ONE TABLE in Data Movement & Streaming

I HAVE 2 DATE FUNCTION IN ONE TABLE

ha142000 — Wed, 19 Mar 2025 21:58:43 GMT

In my table i am having two date

1.order date

2.Delivery date

but when i am using Canonical Date the count of delivery not coming correct as per my source

Re: I HAVE 2 DATE FUNCTION IN ONE TABLE

rwunderlich — Thu, 02 May 2024 19:49:20 GMT

Please provide some more information.

1. A screenshot of your data model.

2. The expression you are using as Count of Delivery.

3. Expected and actual results.

-Rob

Re: I HAVE 2 DATE FUNCTION IN ONE TABLE

ha142000 — Tue, 07 May 2024 08:45:41 GMT

OUTCOME- i am creating a Pie chart where i am showing Count of ( Order deliver id ,order Ship id and Order id) show i need a year fliter of it when ever i click on year it will filter out the pie chat

Re: I HAVE 2 DATE FUNCTION IN ONE TABLE

rwunderlich — Wed, 08 May 2024 18:42:35 GMT

I still feel like you have not provided enough information to fully address your question. But if I had to guess you are getting an incorrect result -- too high -- from Count([ORDER ID]). It's always a bad idea to count key fields because it's ambiguous as to which end of the connection you are counting.

If the ORDER ID count is where you are having problems, try

Count(Distinct [ORDER ID])

If this did not resolve your problem, please provide the actual expression text and the expected and actual numbers.

-Rob