Search found 6 matches
- Tue Oct 29, 2019 11:44 am
- Forum: Help with the Book "Learn to Write DAX"
- Topic: Matrix in Page 42
- Replies: 1
- Views: 148
Matrix in Page 42
Hi, Im triying to get the matrix shown in page 42, related to DistinctCount() customers by categories, but some thing I'm doing bad because when I put CalendarYears in columns, my figures in four years (2001 to 2004), are the same that Totals (18484), In other words, the four columns are equals than...
- Sun Nov 25, 2018 6:03 am
- Forum: Help with the Book "Supercharge Power BI"
- Topic: To buid a table with distinct columns fron two tables
- Replies: 4
- Views: 832
Re: To buid a new table
Hi Ramanav, To be much simpler, suppose you have 2 Look-Up tables and 1 Data table, all conected. The first Look-Up table has 3 columns A, B, C; the second Look-Up table has 3 columns D,E and F; and the Data Table has 3 columns A, D, G,(where G is "Sales" column). What I need is to create ...
- Thu Nov 22, 2018 3:05 pm
- Forum: Help with the Book "Supercharge Power BI"
- Topic: To buid a table with distinct columns fron two tables
- Replies: 4
- Views: 832
Re: To buid a table with distinct columns fron two tables
Hi RamanaV Im using Database example of Matt's Book "Supercharge Power BI" [Total Sales] = SUM(Sales[ExtendedAmount] is a measure in "Sales" data table Customers and Products are lookup tables the name of data base is "AdventureWorks" and you can download it from: http/...
- Tue Nov 20, 2018 1:35 pm
- Forum: Help with the Book "Supercharge Power BI"
- Topic: To buid a table with distinct columns fron two tables
- Replies: 4
- Views: 832
To buid a table with distinct columns fron two tables
Hi Friends, I would appreciate your help to build a table with total sales for 4 disctinct colums from two different tables (Products and customers). For instance the following table: Categories Class Gender MaritalStatus [Total Sales] So, If There are 4 Categories, 4 Class, 2 MaritalStatus and 2 Ge...
- Sat Oct 27, 2018 9:40 am
- Forum: Help with the Book "Supercharge Power BI"
- Topic: TotalMTD doesnt work!!!
- Replies: 2
- Views: 1213
Re: TotalMTD doesnt work!!!
Hi RamanaV
Depite the formula was correct, I eliminale it, I writte it again and the problem was solved. I don't know what happened
Very sorry and very thanks
Carlos
Depite the formula was correct, I eliminale it, I writte it again and the problem was solved. I don't know what happened
Very sorry and very thanks
Carlos
- Tue Oct 23, 2018 11:52 am
- Forum: Help with the Book "Supercharge Power BI"
- Topic: TotalMTD doesnt work!!!
- Replies: 2
- Views: 1213
TotalMTD doesnt work!!!
Hi friends, ¿is it posible that a PBI function doesnt work? Attached you will find the exercise of Supercharge Power BI, page 119: Nº 61- [Total Sales Month to Date] As you can see, figures of Total Sales MTD are equal to Total Sales!!! What I'm doing bad? The formula used seems OK : Total Sales Mon...