Forum Discussion
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
- Manoj_NairSolution Supplier
ANP - try this calculated column DAX for getting EOM value.
If this resolves your query, please accept this as a solution. Thanks
- ANPFrequent Visitor
Thanks Manoj it worked