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
Tag: DAX
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
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 […]
How to Manage Measures in PowerBI
So you have connected all of your data into PowerBI and you have transformed and shaped it. Now all you need to do is create some calculations, know as measures, so you can begin to make some visualizations. Off you go and do the normal SUM, Count and Average DAX functions across a number of the tables […]