Search found 6 matches

by carlos barberis
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...
by carlos barberis
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 ...
by carlos barberis
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/...
by carlos barberis
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...
by carlos barberis
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
by carlos barberis
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...

Go to advanced search