Forum Discussion

wetherington's avatar
wetherington
Frequent Visitor
6 years ago

Calendar Table Data Filter

Hi Everyone,   In my current data model, I have two tables Orders and Invoices in these tables I have a date column which I have associated with my calendar table.  Which works for my Invoice --> C...
Tips and Tricks
wetherington's avatar
wetherington
Frequent Visitor
6 years ago

amitchandak I added a date only column but am receiving #Error.  This is the same formula that I used on my Invoice date only and it worked fine. 

 

Order Table

 

 

Invoice Table 

 

Thanks! 

Wil

Anand24's avatar
Anand24
Super User
6 years ago

Hi wetherington ,

 

From the DAX warning/error message, it is pretty clear here that your 'new_paymentmilestone' column from 'SalesOrder' table is not in date format and that's why FORMAT function is not able to convert it to desired mm/dd/yyyy format.

I guess this is the same reason for the joining not working with SalesOrder table.

 

Please change the data type of your 'new_paymentmilestone' column from 'SalesOrder' table to DATE and try.

 

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!