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]))   T...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Chamalpam , Try

     

    eomonth([End Date], -5)

     

    or

     

    eomonth([End Date], -4)

amitchandak's avatar
amitchandak
Super User
3 years ago

Chamalpam , Try

 

eomonth([End Date], -5)

 

or

 

eomonth([End Date], -4)

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