EVALUATEANDLOG DAX Function (Information)
Return the value of the first argument and also log the value in DAX evaluation log.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Value |
A scalar or table expression. |
|
| Label | Optional |
When specified, it is included in the Label column of the DAX Evaluation Log event as well as a part of the JSON payload. |
| MaxRows | Optional |
Specify the number of rows to return in case of a table expression. The default value is 10. |
Return values
The result of the evaluated Expression.
Remarks
The DAX Evaluation Log is a trace event that can be captured by SQL Server Profiler or by the DAX Debug Output tool.
Related articles
Learn more about EVALUATEANDLOG in the following articles:
-
Introducing the DAX EvaluateAndLog function
Describe how to use the DAX EvaluateAndLog function. » Read more
-
Debugging DAX measures in Power BI
This article describes different techniques to debug a DAX measure that returns an incorrect result, with and without external tools. » Read more
Last update: Nov 14, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://learn.microsoft.com/dax/evaluateandlog-function-dax