Page 67 Results of OR formula not showing up

A dedicated forum to help people when working through the book "Learn to Write DAX"
ado13
Posts: 1
Joined: Mon Nov 26, 2018 6:20 am

Page 67 Results of OR formula not showing up

Postby ado13 » Tue Dec 04, 2018 6:01 pm

Hello

I´ve been having problems with showing the results of this formula onto the pivot table.

The formula in PowerPivot is correct.
imagen power.PNG
imagen power.PNG (15.86 KiB) Viewed 178 times


Does somebody know why this happens?
imagen power1.PNG
imagen power1.PNG (6.05 KiB) Viewed 178 times

imagen power2.PNG
imagen power2.PNG (84.63 KiB) Viewed 178 times

RamanaV
Posts: 29
Joined: Thu Oct 19, 2017 12:57 pm

Re: Page 67 Results of OR formula not showing up

Postby RamanaV » Wed Dec 05, 2018 8:47 am

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


Return to “Help with the Book "Learn to Write DAX"”

Who is online

Users browsing this forum: No registered users and 1 guest

cron