PowerPivot Forum

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 ...

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/...

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...

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

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...