Forum Discussion

ANP's avatar
ANP
Frequent Visitor
3 years ago
Solved

Date Age Calculation... help needed

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 🙂

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

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

3 Replies