Search found 34 matches

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

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

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

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

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

Testing URL

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

Thanks and regards
Ramana
by RamanaV
Wed Dec 05, 2018 8:47 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Page 67 Results of OR formula not showing up
Replies: 1
Views: 2396

Re: Page 67 Results of OR formula not showing up

Hi,

The formula is correct.

You can check like this:
In the Power Pivot window, in the new column, filter to check if there are blanks.
Then check the column DayNumberOfWeek to see if it contains blanks.

Best wishes
Ramana
by RamanaV
Mon Dec 03, 2018 8:11 am
Forum: Help with the Book "Supercharge Power BI"
Topic: DAX Topic FILTER() - Page 106 "Under the Hood"
Replies: 5
Views: 1150

Re: DAX Topic FILTER() - Page 106 "Under the Hood"

Hi,

I asked Matt Allington about this formula.

I also made a mistake in it.

Following is the right formula.

Total Customers with Income of $ 80,000 Under the Hood =
CALCULATE(COUNTROWS(Customers), FILTER(ALL(Customers[YearlyIncome]), Customers[YearlyIncome] >= 80000))
by RamanaV
Sat Dec 01, 2018 9:32 am
Forum: Help with the Book "Supercharge Power BI"
Topic: DAX Topic FILTER() - Page 106 "Under the Hood"
Replies: 5
Views: 1150

Re: DAX Topic FILTER() - Page 106 "Under the Hood"

Hi, It is a typo in the second formula. It should be Total Customers with Income of $ 80,000 Under the Hood = CALCULATE(COUNTROWS(Customers), FILTER(Customers, Customers[YearlyIncome] >= 80000)) Thanks for bringing it out. We will add in errata. With this formula the results are FILTER Under hood.pn...
by RamanaV
Fri Nov 30, 2018 8:38 am
Forum: Help with the Book "Supercharge Power BI"
Topic: DAX Topic FILTER() - Page 106 "Under the Hood"
Replies: 5
Views: 1150

Re: DAX Topic FILTER() - Page 106 "Under the Hood"

Hi, The way CALCULATE function works is - FILTER first, EVALUATE next. i.e. the Filter part of the formula is executed first and then the evaluation is done on the filtered table. So in your under hood formula, you have the FILTER function that has ALL(Customers). This removes all initial filters ap...
by RamanaV
Sun Nov 25, 2018 4:48 pm
Forum: PowerPivot/DAX
Topic: Creating Conditional Columns Filtered Within Rows
Replies: 2
Views: 546

Re: Creating Conditional Columns Filtered Within Rows

Hi, Place a Calculated Column with the following formula (assuming your table as 'Sample') = VAR ThisIDGender = 'Sample'[Gender] VAR ThisID = 'Sample'[ID] RETURN IF(CALCULATE(COUNTROWS('Sample'), FILTER(ALL('Sample'), 'Sample'[ID] = ThisID), FILTER(ALL('Sample'), 'Sample'[Gender] = ThisIDGender)) = ...

Go to advanced search