![]() ![]() I am not sure what will happen when others open this workbook. It is not specifically an intro to DAX queries, but I found it very helpful in learning what can be done. To finish off this process, I have added the following DAX Query EVALUATEĪDDCOLUMNS ( customers, "Cust Sales", ),Īnd my table updates with the full list of customers that have sales > $2,000įor more information about writing DAX Queries, I recommend you take a look at this article at. I am not going to go into DAX as a Query Language here as that is a topic for another day. You have the opportunity to replace the query you added in step 17 with any valid DAX Query. To fix that, you will need to write some DAX Query code. Now this table is the entire Customers table, and what I really wanted was a list of customers that have purchased > $2,000. Returning this text detail in a pivot table would not be a pleasant experience. Select Table from the listĪnd there you have it – a new table in your workbook that is sourced and linked to your data model. You will see the same dialog as in step 4, but this time you have an option to insert a table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |