In this video, we'll take a look at
Power Query in Power BI in Tamil
Formula :
YearX = INT(YEARFRAC('Employee Data'[Date of Join],TODAY(),1))

MonthX =
var difdays = DATEDIFF('Employee Data'[End date],TODAY(),DAY)

return if(MONTH(TODAY())-MONTH('Employee Data'[Date of Join]) not equal to 0, if(difdays less than 30,MONTH(TODAY())-MONTH('Employee Data'[Date of join]),(MONTH(TODAY())-MONTH('Employee Data'[Date of Join]))-1),0)

Click here to download Power BI
Download Link : https://powerbi.microsoft.com/en-us/d...

#Powerbi#microsoftpowerbi#powerbitraining

Click here to view Smart Peer - Power BI Tutorial
https://bit.ly/Smartpeer_PowerBI_Tuto...

Click here to view Smart Peer - Adobe Premiere Pro Tutorial
https://bit.ly/Smartpeer_AdobePremier...

Click here to view Smart Peer - Excel Tutorials
http://bit.ly/Smartpeer_ExcelTutorial

Click here to view Smart Peer - Excel Quizzes
http://bit.ly/SmartPeer_ExcelQuizzes

Click here to view Smart Peer - E-Service
https://bit.ly/Smartpeer_E-Service

Click here to view Smart Peer - SQL Tutorial
https://bit.ly/Smartpeer_SQL_Tutorials


Thank you for taking the time to watch
Subscribe to learn, click the bell icon to reach you
If you have any questions about this video, please leave them in the comments section.

Thank you,
Smart Peer - Selva