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
Icon for Super User rankSuper 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. 

 

 

 

  • Anand24's avatar
    Anand24
    Icon for Super User rankSuper User
    6 years ago

    wetherington,

    Can you change the data type from Power Query Editor once and then check. Do let us know if you face any error with DAX.

     

    Thanks !