Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Date and time parts - DAX Guide

SQLBI
120K subscribers
3.9K views 4 years ago #dax #powerpivot #powerbi
DAY: Returns a number from 1 to 31 representing the day of the month. https://dax.guide/day/ MONTH: Returns a number from 1 (January) to 12 (December) representing the month. https://dax.guide/month/ YEAR: Returns the year of a date as a four digit integer. https://dax.guide/year/ WEEKDAY: Returns a number identifying the day of the week of a date. https://dax.guide/weekday/ HOUR: Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.). https://dax.guide/hour/ MINUTE: Returns a number from 0 to 59 representing the minute. https://dax.guide/minute/ SECOND: Returns a number from 0 to 59 representing the second. https://dax.guide/second/ This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel. How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin... Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot ...more
...more
Date and time parts - DAX Guide
104Likes
3,911Views
2021May 31
DAY: Returns a number from 1 to 31 representing the day of the month. https://dax.guide/day/ MONTH: Returns a number from 1 (January) to 12 (December) representing the month. https://dax.guide/month/ YEAR: Returns the year of a date as a four digit integer. https://dax.guide/year/ WEEKDAY: Returns a number identifying the day of the week of a date. https://dax.guide/weekday/ HOUR: Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.). https://dax.guide/hour/ MINUTE: Returns a number from 0 to 59 representing the minute. https://dax.guide/minute/ SECOND: Returns a number from 0 to 59 representing the second. https://dax.guide/second/ This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel. How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin... Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt #dax #powerbi #ssas #tabular #analysisservices #powerpivot

Follow along using the transcript.

SQLBI

120K subscribers