Search found 39 matches

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

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

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

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

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

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...
by RamanaV
Fri Aug 16, 2019 7:00 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: Internal server error on http://Xbox.com.au/learndax
Replies: 2
Views: 313

Re: Internal server error on http://Xbox.com.au/learndax

Hi Saba,

Please use the URL https://xbi.com.au/learndax and it works. You will be able to download the zipped version of AdventureWorks database and follow through the book.

Hope this helps

Ramana
by RamanaV
Mon Aug 12, 2019 3:13 pm
Forum: Power Query
Topic: Convert T-SQL to Power Query
Replies: 1
Views: 212

Re: Convert T-SQL to Power Query

Hi,

the following should help
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each [Column3] < 20),
#"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Column3"})
by RamanaV
Thu Aug 08, 2019 1:24 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: issue with parameter formula page 141
Replies: 1
Views: 270

Re: issue with parameter formula page 141

Hi, Have you defined the measure [Selected Value] correctly? Selected Value = MAX(Increase[Value]) Increase is the table with the values in Slicer. First check that your measure [Selected Value] is working correctly. Then use it in defining the measure Total Margin with Selected Increase = [Total Ma...
by RamanaV
Thu Aug 08, 2019 11:35 am
Forum: Help with the Book "Supercharge Power BI"
Topic: Chapter 15 YTD Functions Exercise 63 & 64 Topic is solved
Replies: 2
Views: 686

Re: Chapter 15 YTD Functions Exercise 63 & 64 Topic is solved

Your DAX formulas and your understanding is correct. You used Calendar Year for Rows. So YTD started with January and ended with December. Smallest value in Jan and largest value in Dec Your FYTD also started and ended correctly. July to June in first case and April to March in the second case. In f...
by RamanaV
Mon Dec 17, 2018 10:11 pm
Forum: Testing
Topic: Testing URL
Replies: 5
Views: 3977

Testing URL

This post is to check the URL that gets included in the post notification email.

Thanks and regards
Ramana

Go to advanced search