Forum Discussion

Chamalpam's avatar
Chamalpam
Frequent Visitor
3 years ago
Solved

Cannot manipulate Date measure

Dear PowerBI Experts,

 

I have below date measure

End_Date = Date (year(2023),month(01),day(31))

 

And below measure

New_Date = DATE(YEAR([End_Date]),MONTH(([EndDate])-5),DAY([EndDate]))
 
The result i want is the date to appear as 30.09.2022 however i cannot seam to get this working. Any Advise?
 
Please help!
 

 

Need Help

3 Replies

    • Chamalpam's avatar
      Chamalpam
      Frequent Visitor
      3 years ago

      Thank you amitchandak . It worked! I have typed it wrong the result i am looking for is 30.09.2022. 

       

      the result i am getting is 30.09.2023

       

      it should also work if the end_date is as below

      End_Date = Date (year(2022),month(12),day(31))

       

      result should be 31.08.2022