in PowerBI by (14.5k points)
What are the three fundamental concepts of DAX?

1 Answer

0 votes
by (14.5k points)


This is how the formula is written—that is, the elements that comprise it. The Syntax includes functions such as SUM (used when you want to add figures). If the Syntax isn't correct, you'll get an error message.


These are formulas that use specific values (also known as arguments) in a particular order to perform a calculation, similar to the functions in Excel. The categories of functions are date/time, time intelligence, information, logical, mathematical, statistical, text, parent/child, and others.


There are two types: row context and filter context. Row context comes into play whenever a formula has a function that applies filters to identify a single row in a table. When one or more filters are applied in a calculation that determines a result or value, the filter context comes into play.

Related questions

+1 vote
asked Jan 16 in PowerBI by Robin (14.5k points)
+1 vote
+1 vote
asked Jan 16 in PowerBI by Robin (14.5k points)