Search found 5 matches

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: 767

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: 767

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: 767

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: 1122

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: 1122

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