Scribd
Upload
2 views1 page

2.date & Time Functions

The document provides an introduction to DAX, focusing on Date and Time functions. It explains the creation of new tables for better analytics, specifically DimDate and DimGeography, and outlines various DAX functions like CALENDAR, CALENDARAUTO, and DATE. Additionally, it includes formatting functions for displaying day and month names and numbers.

Uploaded by

nandinimugadur
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views1 page

2.date & Time Functions

The document provides an introduction to DAX, focusing on Date and Time functions. It explains the creation of new tables for better analytics, specifically DimDate and DimGeography, and outlines various DAX functions like CALENDAR, CALENDARAUTO, and DATE. Additionally, it includes formatting functions for displaying day and month names and numbers.

Uploaded by

nandinimugadur
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Introduction To DAX

Date & Time Functions:-


New Table -
Why new table? -For Neat Analytics
How to Create?
Create DimDate and DimTime(Populate the data)
DimDate -
Date, YearNo, SemNo, QuarterNo, MonthNo, MonthName, WeekNo, DayNo, DayName
DimGeography -
Country, State, City
CALENDAR - CALENDAR(StartDate, EndDate) ,
CALENDAR(DATE(Year, Month, Day),DATE(Year, Month, Day))

CALENDARAUTO -It will not take any start date and end date.
Will give dates between Starting Date of minimum year and current date.

DATE - DATE(Year,Month,Day)
MONTH
YEAR
WEEKNUM
QUARTER
SEM - IF(Quarter<2, Sem1,Sem2)
TODAY ()
NOW ()
EOMONTH-End Date

DayName=FORMAT(Emp[Date],'DDDD')

MonthNumber=FORMAT(Emp[Date],'MM')
MonthName=FORMAT(Emp[Date],'MMMM')
1
Page

THARUN CHALLA 1

You might also like