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
amitchandak's avatar
amitchandak
Super User
6 years ago

wetherington , as long as data type is date, it should work. I doubt it has a timestamp. Change the problematic Date's Datatype as datetime and change format that display time also.

 

If it has time create a date and join with date table

New column

Date =[Datetime].date

 

  • 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 !!!

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      wetherington , seems like newpayment milestone is text. First, try to change that to date

      • wetherington's avatar
        wetherington
        Frequent Visitor
        6 years ago

        I tried to change the column to both Date and Date/time.  Still didn't work.