Forum Discussion

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...

amitchandak
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

Icon for Memorable Member rank

Memorable Member

6 years ago

Anonymous

I would suggest you to read the documentation on Datediff.

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

If you need to show only positive numbers, use them in IF statement.