Search found 29 matches

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

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

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

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

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

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)) = ...
by RamanaV
Sun Nov 25, 2018 3:27 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: To buid a table with distinct columns fron two tables
Replies: 4
Views: 143

Re: To buid a table with distinct columns fron two tables

Hi, You can do it in Power Query. Follow these steps. 1. Merge the tables Products and Sales using ProductKey column. Use Merge Tables as New option. It creates a new query - Merge1. 2. In Merge1, expand the Table column (column on the extreme right), keeping only CustomerKey and ExtendedAmount colu...
by RamanaV
Wed Nov 21, 2018 9:34 am
Forum: Help with the Book "Supercharge Power BI"
Topic: To buid a table with distinct columns fron two tables
Replies: 4
Views: 143

Re: To buid a table with distinct columns fron two tables

Hi, From where the [Total Sales] coming from? Do you have a Sales table with SalesAmount column? and is [Total Sales] a measure with the formula as SUM(Sales[SalesAmount])? I am assuming that you have the above information. Otherwise you need to have that. Sales table is your Data table. You have 2 ...
by RamanaV
Sat Nov 03, 2018 9:57 am
Forum: PowerPivot/DAX
Topic: trying to convert excel formula to PowerBI
Replies: 2
Views: 278

Re: trying to convert excel formula to PowerBI

Hi, First, you should stop thinking about data in cells. In Power BI data exists and referred to in columns and not in cells. Second, unlike in Excel the calculations can happen in any order across rows. i.e. not necessarily in the order row 1, row 2, ... Actually a sample workbook would be easy to ...
by RamanaV
Wed Oct 31, 2018 8:51 am
Forum: Power BI Desktop/Service
Topic: Filtering formula by various dates
Replies: 9
Views: 598

Re: Filtering formula by various dates

Hi, Is this resolved?
by RamanaV
Sun Oct 28, 2018 9:49 am
Forum: Power BI Desktop/Service
Topic: Filtering formula by various dates
Replies: 9
Views: 598

Re: Filtering formula by various dates

Hi, I suggest the following. First please check if the numeric slicer is giving correct results on selection of different Year values. Then the issue - it works when Year is hard-coded to 2018 and otherwise not - will be resolved. Next check your formulas, to see where a datetime is expected and whe...

Go to advanced search