Forum Discussion

MaleneL's avatar
MaleneL
Resolver I
3 years ago
Solved

Last date last Year DAX

Hi All
hope you can help me, and I have probely overlooked a simpel solution.

I need to get the last date for last year into a tavel in Desktop by DAX, 

so if I have 

02-02-20223  then 31-12-2022

05-06-2023 then    31-12-2022

04-05-2022 then 31-12-2021

 

and so on any 

pls help ;O)

Malene

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi MaleneL 
    Try this DAX formula in calculated column : 

    Last date LY = date(YEAR('Table'[Date])-1,12,31)

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

3 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    3 years ago

    Hi MaleneL 
    Try this DAX formula in calculated column : 

    Last date LY = date(YEAR('Table'[Date])-1,12,31)

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

  • MaleneL's avatar
    MaleneL
    Resolver I
    3 years ago

    YES!! it work, I must have done something wrong, because I had tryed with that but it didn't work.

     

    Thank you!