Power BI Interview Questions

Category - DAX Calculations

Articles

Same Period Last Year Function in Power BI
What is DAX? (Data Analysis Expressions)
What is the difference between a Calculated Column and a measure?
What is the difference between sumx and sum in power bi?
What is the difference between the CALCULATE and CALCULATETABLE functions in DAX/Power BI?
the difference between Summarize and SummarizeColumns
What is the difference between all and allselected in power bi?
Difference between filtering data in CALCULATE with and without FILTER Expression
"I have a sales table with a measure called 'Gross.' The sales table is linked to the geography table via the City ID column. The geography table includes columns for City ID, City, and State. I have created the following measure
What is the difference between RELATED and RELATEDTABLE?
 What is the difference between search and find?
 If in the above visual, I add a column- city id, which also same granularity as a city, and from the same table, will I get the same ranks?
What is the difference between skip and dense in Rank?
What are the top 10 states by gross sales from the 'SalesData' table?
What are the common scenarios in which the Grand Total does not equal the sum of rows in both countable and summable measures?
What are some best practices related to Time Intelligence or Date Tables?
What do mean by MTD, QTD, and YTD in Power BI?
Which functions can I use to obtain MTD, QTD, and YTD results in Power BI?
Practical Challenge Questions 1 DAX
Practical Challenge 2 DAX
Practical Challenge 4 DAX
Practical Challenge 3 DAX
Practical Challenge 5 DAX
In what scenarios can I use the RELATED function?
What does FIRSTNONBLANKVALUE function do?
Give examples of Power BI/DAX functions that are very similar to SQL window functions.
What are the differences between DAX functions Rank and Rankx?
What is the difference between GENERATE and CROSSJOIN
What is the difference between the CALENDAR and CALENDARAUTO
What is the best way to find min values 5 columns or measures for a given table row or visual row?
How can we repeat the value of a measure or column?
How can we generate a series of odd numbers or even numbers?
Provide a measure that gives the Running/cumulative total using the date table
How to get Top/bottom performer?
How to add a unique sequence number field in Power BI visual?
How to append two tables in DAX
Give some examples of measures we can create using the Window Function.
How do I calculate the unique combinations of two columns in Power BI?
How do I sort a column of matrix visual in Power BI using a “Month Year” field in descending order?
Is there a way to set a date slicer to always show today’s date, or a month slicer to always show the current month in Power BI?
Provide a measure that gives the Running/cumulative total using the date table.
How to get Top/bottom performer?
How to add a unique sequence number field in Power BI visual?
Give some examples of measures we can create using the Window Function.
What is the difference between distinct and unique values in Power Query’s column distribution?
+ 37 Articles
Show All Articles