Search found 44 matches

by RamanaV
Tue Jan 14, 2020 2:20 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: SUMX result in power pivot
Replies: 1
Views: 459

Re: SUMX result in power pivot

SUMX is an aggregation function. That is why you are getting the same result (which is actually the sum of all the products) in every row. You can add a calculated column as = Base[Price]*Base[Quantidade] And, it serves the purpose. However, it is not a good practice to add a calculated column in th...
by RamanaV
Thu Jan 02, 2020 8:46 am
Forum: PowerPivot/DAX
Topic: Row()
Replies: 2
Views: 163

Re: Row()

This problem can be solved in Power Query before loading the data into the data model. The trick is to use "Nested Index", which I learnt from Matt Allington in his Power Query Online Training course. https://exceleratorbi.com.au/power-query-online-training. Please find the solution in the...
by RamanaV
Tue Dec 24, 2019 9:37 am
Forum: PowerPivot/DAX
Topic: Calculated Columns not refreshing [SOLVED]
Replies: 3
Views: 251

Re: Calculated Columns not refreshing

I don't think you need a calculated column to solve this.
You can merge the data in Power Query before loading it into data model and then it works.

If you are not sure how to do it, please share a sample workbook.
I will show you the solution.
by RamanaV
Tue Dec 17, 2019 9:33 am
Forum: PowerPivot/DAX
Topic: Relationship issue
Replies: 4
Views: 277

Re: Relationship issue

You can actually merge the data before loading into data model using Power Query (Get Data -> Transform Data).
I have given the solution in the attached workbook
You can see the final data table loaded into Excel

Hope this helps
by RamanaV
Mon Dec 16, 2019 6:59 pm
Forum: PowerPivot/DAX
Topic: Relationship issue
Replies: 4
Views: 277

Re: Relationship issue

Can you share a sample workbook?

Want to look at the data and then look at the relationships to resolve the issue

Thanks
by RamanaV
Sun Nov 17, 2019 10:14 pm
Forum: PowerPivot/DAX
Topic: PowerPivot: Help with conditional split column
Replies: 2
Views: 142

Re: PowerPivot: Help with conditional split column

Hi, Actually it is difficult to give an answer with just one value. However assuming that all the values in the column are in the same format, I have provided a solution. Please note that we cannot have such a conditional split (do not split if , is within parenthesis) A better solution is extractin...
by RamanaV
Sun Nov 17, 2019 11:00 am
Forum: Power BI Desktop/Service
Topic: Power BI desktop, power query transposing part of a table
Replies: 2
Views: 573

Re: Power BI desktop, power query transposing part of a table

stasinek,

A good solution.
Thanks for that.

Laure,

You said you are looking for a solution in Power BI Desktop
Power Query commands are the same in both Excel and Power BI Desktop

For your quick reference, here is the solution in Power BI Desktop

Ramana
by RamanaV
Wed Nov 06, 2019 11:45 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Table Properties displays SQL statement only . . .
Replies: 4
Views: 472

Re: Table Properties displays SQL statement only . . .

Supercharge Excel is the second edition of Matt Allington's book Learn to Write DAX. Learn to Write DAX was written using Excel 2013 interface. Supercharge Excel uses Excel 2016 and is an improved version. Supercharge Power BI uses Power BI Desktop as the interface. The learning experience is same i...
by RamanaV
Fri Sep 27, 2019 11:24 am
Forum: Help with the Book "Supercharge Power BI"
Topic: Chapter 14 - Repeat Customers
Replies: 4
Views: 483

Re: Chapter 14 - Repeat Customers

Hi, Good to know that you are able to understand and proceed. To get a good understanding on how DAX formulas work, it would be useful to observe the data keenly. If you look at Sales table, there is a column - SalesOrderNumber, which is essentially an invoice Now, one invoice will have one OrderDat...
by RamanaV
Mon Sep 23, 2019 4:09 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: Chapter 14 - Repeat Customers
Replies: 4
Views: 483

Re: Chapter 14 - Repeat Customers

Hi, Calculate the no. of distinct invoices first Distinct No. of Invoices = DISTINCTCOUNT(Sales[SalesOrderNumber]) Now put a Table visual in your report and place Customers[CustomerKey] on Rows and [Distinct No. of Invoices] on Columns You will then see how many invoices each customer has. Next, you...

Go to advanced search