theparthee
How does the EARLIER Function work?
Last Updated: December 3, 2025The EARLIER function in DAX is used to access data from an earlier (outer) row context while you’re working inside...
What is the purpose of the FILTER function?
Last Updated: December 3, 2025The FILTER function in DAX is used to return a subset of rows from a table that meet specific conditions....
What is the difference between CALCULATEand CALCULATE TABLE?
Last Updated: December 3, 2025The main difference between CALCULATE and CALCULATETABLE in DAX is in what they return and how they operate — both...
What is the purpose of the RELATED function?
Last Updated: December 3, 2025The RELATED function in DAX is used to fetch a value from a related table — specifically, it brings data...
What is a filter context in DAX?
Last Updated: December 3, 2025Filter context in DAX refers to the set of filters that are currently applied to evaluate a calculation — basically,...
What is a row context in DAX?
Last Updated: December 3, 2025Row context in DAX refers to the current row that DAX is evaluating when performing a calculation. You can think...
What is the difference between SUM and SUMX?
Last Updated: December 3, 2025The main difference between SUM and SUMX in DAX is that SUM simply adds up all the values in a...
What is the syntax of a DAX function?
Last Updated: December 3, 2025The syntax of a DAX function is quite similar to Excel, but it’s more powerful because it works with data...
What is a measure in DAX?
Last Updated: December 3, 2025A measure in DAX is basically a calculation that is evaluated dynamically based on the filters and context in a...
What are the key data types supported in DAX?
Last Updated: December 3, 2025In DAX, the key data types are quite straightforward but understanding how they behave internally is really important for writing...