Topic: DAX

       175 articles of 385 posts
article –

Understanding LOOKUPVALUE

The LOOKUPVALUE function retrieves values from a table in a simple way, but it involves a hidden level of complexity. This article provides full coverage of the LOOKUPVALUE internals, alongside several performance considerations.  Read more

DAX 101 –

Mark as Date table

Tabular models (including Power BI) require marking the Date table as a date table to get appropriate results with time intelligence calculations. This article explains why this setting is required.  Read more