What Are Table Functions In DAX - (1.14) Ultimate Beginners Guide to DAX 2019

Follow along to the beginners guide DAX tutorials by using the demo data available for download. Enjoy!

Details of what you will learn during this course
Learn - what DAX is and why you need to learn it when using Power BI
Learn - the basics of DAX calculations
Understand - formula syntax, writing comments & variables
Review - how the data model and DAX calculations work together
Learn - what the most important concept of DAX is - CONTEXT
Understand - what the CALCULATE statement does
Learn - what table functions are and when to use them
Review - time intelligence functions
Understand - how important learning DAX well is when using Power BI

Here are the specifics for the course
Learn how to;
Use DAX formula with Power BI
When and where to use DAX functions
Utilise some of the great features built into the DAX formula bar
Use the data model in combination with DAX formula
Understand the concept of CONTEXT
Use the CALCULATE statement
Create filters using table functions
Incorporate time intelligence functions in your analysis
Become a DAX master by combining patterns of DAX formula

DESCRIPTION
In this video tutorial I describe what table functions are in the DAX formula language.

Table functions are key to advanced work in Power BI and allow you to complete powerful analysis with relatively simple formulas

***** Learning Power BI? *****

[willyms]

I'm a GREAT fan of your videos! keep doing the great job

[ShabnamKhan-vkfj]

This is very helpful, do you mind elaborating on the "VALUE" type, maybe another example?

[rojanshrestha]

yeah!! thanks for the video. lot of things to grasp. but how do you load the visual table into the data model for visualization.

[giri]

Hi

Can I divide the table depend on sale value high and low please??

[ModestKarma]

For the sold per day would it calculate based on all days or just days that the product was sold? For products that were not sold everyday it might show a higher average of it is just using the dates in the current products filter context. If I wanted it to be products sold from the first day the product was sold to the last day the product was sold including days nothing was sold how would you do that? Or say maybe if it is a retail store closed on Sundays, all days between the first day the product was sold to the last day the product was sold excluding Sunday ?

[rayng]

It'll be nice if you add some padding under your keyboard.

[ntm]

I really appreciate your work, these videos are very helpful! On the last part of this video though, I dont understand why you're getting 9528 in the ALL calculation since that's the filtered total for 2016. Shouldnt you get all Qty Sold all years because you've removed initial context with Calculate?

[holahandstrom]

Great if I could mark a portion of the DAX-formula, then press F9 (like in Excel) and PowerBI create a Table of that.

[jeskow]

If you were to create another calculation after the one using all, the existing filters still apply correct?

[elizabethlaurentalboy]

Hi, I need help!
I'm trying to return the value for where there are costs, but no revenues. But I have multiple duplicate sales orders. So when I use a
=calculate(sum(cost of sales), net revenues=0). I also get the value for Sales Order 1 below. I don't want sales order number 1. I only want the total for Sales Order 2.
Can you help? Would you use the values formula you shared? How would you include it?


Sales Orders Revenues Cost of Sales
1 0 15
1 30 0
2 0 15
2 0 20

[mathewinmuscat]

Hi, need your help. How do I create a new table by filtering data with a selected value from a slicer? Example CALCULATETABLE(HRDATA, HRDATA[Join Yr] = [selected year])

[zakirhossain]

Many thanks for such a great video. I have a question, is "Values" function the same as "Disctictcount" function?