## DAX LOOKUPVALUE – Power BI and Excel Power Pivot

Learn how to lookup a value from a different table in DAX for Power Pivot and PowerBI, with no relationship using LOOKUPVALUE

## Avoid Transformation steps in DAX (Excel and PowerBI)

Avoid Transformation steps in DAX (Excel and PowerBI) and learn to carry out data transformation in Power Query

## Date tables for DAX users – Power BI and Power Pivot

Everyone should use a date table in Power BI, but creating one with DAX is not the most optimal solution. We have a lot to cover in this article on date tables,

## Why and how to Keep Dimensions & Facts tables separate – DAX modeling

Modeling for DAX Power Pivot and Power BI – Learn why and how you should keep dimensions and facts tables separate.

## DAX AND OR IN or syntax(&& ||) – Which one?

Learn how to create conditional statement in DAX using AND, OR, IN and the syntax && and ||

## 6 DAX tips for Excel and Power BI users

If you are learning DAX for Power Pivot or Power BI then here are 6 DAX tips you should be following

## Calculate 50 & 100-Day Moving Average with DAX

Following on from last weeks post, Connecting Excel to Coinmarketcap data for live ticker information and historic pricing, I thought I would share with you some basic indicators that you can add to your Excel Cryptocurrency Dashboard.  This week we are going to look at calculating 50 and 100-day moving averages using DAX In the […]

## DAX SUM and SUMX Functions

The role of both DAX SUM and SUMX functions is to add numerical data together. Yet both these functions are rather different. Let’s talk about the SUM function first. The SUM function is simple. It takes a column of data and adds the values to give a total. It works like the sum function in […]

## SWITCH Function in DAX for Excel and Power BI

The SWITCH function in DAX can be used to replace the nested IF statement.  It is both easier to read and easier to write. SWITCH was introduced in PowerBI in Nov 2016 and it is also available in updated versions of Excel 2016 By the end of this article and examples, you will Understand the […]

## DAX – FILTER inside CALCULATE

CALCULATE in DAX is such a powerful and complex function to fully understand.  In essence what CALCULATE will do is modify the current filter context.  And it does this by evaluating both the current filter context and the filters applied by CALCULATE. The syntax for CALCULATE is: =CALCULATE ([Expression], filter1, filter2…..) So if CALCULATE contains […]