Context Transition in DAX for PowerPivot, Power BI & SSAS
Learn about Context Transition In DAX – The process of moving from row context to filter context
Category: DAX
Related and RelatedTable – DAX for Power Pivot, Power BI and SSAS
When we looked at the SUM and SUMX expressions in an earlier article and video we introduced the use of RELATED. You will remember this expression; =[Qty] * RELATED(products[Sales Price]) Where we took the qty sold from the sales table and we went across to the related products table and found the relevant sales price […]
DAX COUNT and COUNTX – Impact of Using Measures V’s Calculated Columns
Learn the difference of using Measure and calculated columns in DAX for Power Pivot or Power BI
What is DAX (DATA ANALYSIS EXPRESSIONS)
Data Analysis Expression language or DAX, was originally released with Power Pivot in Excel in 2010 by Microsoft. It’s a functional language that is very similar to excel, as you would expect as it was part of the excel tools. Its initial basic function was to allow excel users solve more complex business problems. Now, […]
DAX Divide Function – DAX for Power BI and Power Pivot
When you are working in Excel it is relatively easy to divide two numbers. You take the value from one cell, and divide it by the value or the in another cell. For Example =B3/B2. Divide is a basic mathematical operator. In Excel if you try to divide a value by zero you will get the error […]