- Courses
- Tutorials
- Practice
- Jobs
- Introduction to Power BI - Dashboard
- Power BI - Dashboard Actions
- Power BI - Create a Stacked Bar Chart
- Power BI - How to add Reports to Dashboards?
- Power BI - Report Level Filters
- Power BI - How to Format Matrix?
- Power BI - Slicer
- Power BI - How to Format a Card?
- Power BI - Format Multi-Row Card
- Power BI - How to Create a Map?
- Power BI - How to Format Map
- Power BI - How to Create a Treemap?
- Power BI - How to Format Tree Map?
- Connect Power BI Desktop with Power BI Service
- Power BI - Create a Table
- Power BI - How to Format Table?
- Power BI - Create a Stacked Column Chart
- Power BI - How to Format Stacked Column Chart?
- Power BI - Create 100% Stacked Column Chart
- Power BI - Create 100% Stacked Bar Chart
- Power BI - Format Stacked Bar Chart
- Power BI - How to Create a Stacked Area Chart
- Power BI - Format Area Chart
- Power BI - Create a Radial Gauge Chart
- Power BI - Key Performance Indicators (KPIs) Dashboards
- Power BI - How to Create Calculated Columns
- Power BI- Functions
- Power BI- DAX Window Function
- Power BI - DAX Logical Functions
- Power BI - DAX Information Functions
- Power BI - DAX TEXT Functions
- Power BI- DAX Index Function
- Power BI - DAX Trigonometric Functions
- Power BI - DAX COUPDAY Financial Function
- Power BI - DAX Depreciation Functions
- Power BI - Distinct() function
- Power BI - DAX Math Functions
- Power BI - DAX Counting Functions
- DAX Bitwise Functions in Power BI
- Power BI Interview Questions and Answers
Time Intelligence Function & ChatGPT - Day 10
Question 1
What is the primary purpose of DAX Date functions in Power BI?
- A
To format visuals
- B
To work with date and time values for calculations
- C
To create relationships between tables
- D
To filter categorical data
Question 2
What does the DATEADD function do in DAX?
- A
Adds numeric values to a column
- B
Shifts dates forward or backward by a specified interval
- C
Calculates the difference between two dates
- D
Returns today’s date
Question 3
When is the DATEADD function commonly used?
- A
Creating calculated columns
- B
Comparing current period values with previous periods
- C
Formatting date text
- D
Removing duplicate dates
Question 4
What is the main purpose of YTD (Year-to-Date) functions in DAX?
- A
To calculate values for a single day
- B
To aggregate values from the start of the year to the current date
- C
To calculate weekly totals
- D
To filter future dates
Question 5
Which DAX function is commonly used for Year-to-Date calculations?
- A
DATEADD
- B
TOTALYTD
- C
DATEDIFF
- D
CALENDAR
Question 6
Why are Time Intelligence functions important in Power BI?
- A
They improve visual formatting
- B
They enable analysis across time periods
- C
They clean missing data
- D
They optimize model size
Question 7
In Microsoft Power BI DAX, which function is used to get values from the same period in the previous year?
- A
TOTALYTD()
- B
SAMEPERIODLASTYEAR()
- C
COUNT()
- D
SUM()
There are 7 questions to complete.
