Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX: Why is LastDate not working?

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

     

    Thanks so much for your reply! I just figured it out

     

    That wasn't the reason. The column was formatted as datetime so I needed to specify .date and it works perfectly. The "Distinct" filter would have fixed the dupilicate columns if that was the issue I think.

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI Anonymous 

      THis is because your column has duplicate dates. To avoid this, if you have Date table you can use the date from that date table, which wil be unique and solve the issue.

     

    Thanks
    Raj

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

       

      Thanks so much for your reply! I just figured it out

       

      That wasn't the reason. The column was formatted as datetime so I needed to specify .date and it works perfectly. The "Distinct" filter would have fixed the dupilicate columns if that was the issue I think.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thats correct. Glad that you fixed it!