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
Icon for Super User rankSuper User
3 years ago

Chamalpam , Try

 

eomonth([End Date], -5)

 

or

 

eomonth([End Date], -4)

Chamalpam's avatar
Chamalpam
Frequent Visitor
3 years ago

This works. Thank you very much amitchandak