cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mfacundo Frequent Visitor
Frequent Visitor

Wrong Date Showing in Table Visualization

My problem is this: I have two Tables of the treated products, the Incoming table has several columns with information about each product such as: ID, Owner, Problem, Date of Arrival, Date of Analysis, Code of Problem etc. The second table is 'Outgoing' has several information already present in the table 'Incoming' and the unique ones of it as: Date of treatment, Procedure used, Return Date, etc.

 

In my Dashboard I need a Table View where the columns are Incoming table columns, Measures created from incoming table data, qualitative columns with "yes" or "no", and so on.
But I'm having trouble with a specific column called "Return Date," which is one of the few columns that uses information from another table other than Incoming.

 

The column follows the following DAX formula:

Return Date = IF ('Incoming' Item Returned = "Yes"; CALCULATE (MIN ('Outgoing'Return Date)); BLANK ())

 

 

The problem is that this formula returns the date of return of the first product that was returned from the beginning of the business, rather than the date of return of the product in question on the line. For example, a product returned on 11-26-2017 appears with the return date as 12-02-2014.

 

The 'Incoming' and 'Outgoing' Tables are related by a third ID's table because the same ID can appear multiple times in both the Incoming table and the Outgoing Table.

 

Help me please! I've tried every way I know in the last 5 days and I did not get anything. Smiley Sad

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Wrong Date Showing in Table Visualization

@mfacundo,

 

Based on the above, you may take advantage of CROSSFILTER Function to set cross-filter direction to both.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
mfacundo Frequent Visitor
Frequent Visitor

Table shows wrong date

 
My problem is this: I have two Tables of the treated products, the Incoming table has several columns with information about each product such as: ID, Owner, Problem, Date of Arrival, Date of Analysis, Code of Problem etc. The second table is 'Outgoing' has several information already present in the table 'Incoming' and the unique ones of it as: Date of treatment, Procedure used, Return Date, etc.

In my Dashboard I need a Table View where the columns are Incoming table columns, Measures created from incoming table data, qualitative columns with "yes" or "no", and so on.
But I'm having trouble with a specific column called "Return Date," which is one of the few columns that uses information from another table other than Incoming.

The column follows the following DAX formula:

Return Date = IF ('Incoming' [Item Returned] = "Yes"; CALCULATE (MIN ('Outgoing'[Return Date])); BLANK ())

The problem is that this formula returns the date of return of the first product that was returned from the beginning of the business, rather than the date of return of the product in question on the line. For example, a product returned on 11-26-2017 appears with the return date as 12-02-2014.

The 'Incoming' and 'Outgoing' Tables are related by a third ID's table because the same ID can appear multiple times in both the Incoming table and the Outgoing Table.

Help me please! I've tried every way I know in the last 5 days and I did not get anything. Smiley Sad
Community Support Team
Community Support Team

Re: Wrong Date Showing in Table Visualization

@mfacundo,

 

Based on the above, you may take advantage of CROSSFILTER Function to set cross-filter direction to both.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.