date and time functions ,create dimdate table in power bi dax
DimDate =
ADDCOLUMNS (
CALENDAR (MIN(Sheet1[ORDATE]), DATE(YEAR(NOW()), month(now()),DAY(now() ))),
"Year", YEAR([Date]),
"Month", MONTH([Date]),
"Day", DAY([Date]),
"Weekday", WEEKDAY([Date]),
"Quarter", QUARTER([Date]),
"Week Number", WEEKNUM([Date]),
"Year Fraction", YEARFRAC(DATE(2023, 1, 1), [Date]),
"Day of Year", DATEDIFF(DATE(YEAR([Date]), 1, 1), [Date], DAY),
"End of Month", EOMONTH([Date], 0),
"Start of Next Month", EDATE([Date], 1),
"Hour", HOUR(NOW()),
"Minute", MINUTE(NOW()),
"Second", SECOND(NOW()),
"Current Time", TIME(HOUR(NOW()), MINUTE(NOW()), SECOND(NOW())),
"Current Time Value", TIMEVALUE(TIME(HOUR(NOW()), MINUTE(NOW()), SECOND(NOW()))),
"Today's Date", TODAY(),
"UTC Now", UTCNOW(),
"UTC Today", UTCTODAY(),
"Weekday Number", WEEKDAY([Date]),
"text to date", DATEVALUE("2022-10-12"),
"text to time", TIMEVALUE("14:30:00"),
"Network Days in Month", NETWORKDAYS(DATE(YEAR([Date]), MONTH([Date]), day([Date])), EOMONTH([Date], 0))
)
