Topic: Power BI

       109 articles of 215 posts
article –

KPIs in Tabular models for Power BI and Excel

A Tabular model can define a measure as a Key Performance Indicator (KPI), thus providing a visual indicator for status and trend. This article describes in detail the KPI settings needed to get the best result using Power BI and…  Read more

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

article –

Introducing LOOKUPVALUE

This article shows the reader how to use LOOKUPVALUE, which is a handy function for any developer to have in their toolbelt.  Read more