Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Month difference calculation

Hi,     Please help me  to solve below logic.   if date1(Month) column greater than Date2(month) column  and having month difference as 2 month then return "2 month difference" if date1(Month) c...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

datediff(date1,date2, MONTH)

 

refer https://docs.microsoft.com/en-us/dax/datediff-function-dax

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970


https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601