Date Age Calculation... help needed

[ANP]

Hello all, new to power bi.. I have one date type column logged date .. I want to create one new column named Age which says difference between logged date and a constant which is End of month of the maximum available logged date in the column. I tried both in power query editor or power bi desktop but unable to achieve.. what I could got the difference between logged date and End of month of that particular date.. Eg . Logged date lets say 1 Oct 2022 , 10 nov 2022 then Age column should have 60 and 20 respectively correctly.. what I am getting is 29 and 20.. hope that is clear. basically the second parameter in DATEDIFF , I am unable to make it a constant. Thanks in advance 🙂

[Manoj_Nair · Accepted solution]

@ANP - try this calculated column DAX for getting EOM value.  

If this resolves your query, please accept this as a solution. Thanks

[ANP]

Thanks Manoj it worked

[djurecic]

Hi @ANP ,

 You might consider adapting something like this date table with built in end-of month values.

https://radacad.com/all-in-one-script-to-create-calendar-table-or-date-dimension-using-dax-in-power-...