Edit Table Properties Problem

Anything related to PowerPivot and DAX Formuale
kdibai
Posts: 1
Joined: Sun Jun 04, 2017 12:17 am

Re: Edit Table Properties Problem

Postby kdibai » Sun Jun 04, 2017 12:18 am

Same thing here. Searched everywhere, no solution. Looking foward for Microsoft's answer.

PaulInSydney
Posts: 7
Joined: Sat Dec 10, 2016 2:43 pm

Re: Edit Table Properties Problem

Postby PaulInSydney » Sun Jul 30, 2017 4:08 pm

Hey everyone,

I have this issue as well, its Excel 2016, on another forum somebody reinstalled their excel 2016 which fixed it, but only on a temp basis as it was soon back. I cant believe I am now going to have to do this on Excel 2010 and not 2016. Pathetic. For those who would like to know more, this is the URL I read on it...

https://answers.microsoft.com/en-us/mso ... c002615b52

...looks like this has been an issue for about 6 months, considering it renders powerpivot almost useless you would think some urgency would be the order of the day.

Regards,
Paul.

rigger1
Posts: 1
Joined: Sat May 26, 2018 8:24 pm

Re: Edit Table Properties Problem

Postby rigger1 » Sat May 26, 2018 8:32 pm

Hi

I have just started learning PowerPivot with the book learn to write DAX and encountered this same problem on excel 2016. Please can you let me know if there is a fix or work around available of this issue.

Thanks

jarreau82
Posts: 1
Joined: Sat Jun 23, 2018 1:31 am

Re: Edit Table Properties Problem

Postby jarreau82 » Sat Jun 23, 2018 1:50 am

I'm having this issue as well. Has there been any resolution?

Dipak
Posts: 1
Joined: Tue Aug 14, 2018 1:22 am

Re: Edit Table Properties Problem

Postby Dipak » Tue Aug 14, 2018 1:23 am

just chiming in that i am running into this same issue.

What i did for now to move on is manually edit the SQL query, first of all i don't understand why Excel is showing me SQL in a dax course. but okay. after almost 2 years and no reasonable resolution from the author or anyone else, this is what id did to resolve it for myself.

Replace Select Calendar.* FROM Calendar with the code below

Code: Select all

SELECT ID
 ,DATE
 ,DayNumberofWeek
 ,DayNumberofMonth
 ,DayNumberofYear
 ,WeekNumberofYear
 ,MonthName
 ,MonthNumberofYear
 ,CalendarQuarter
 ,CalendarYear
 ,Period
FROM Calendar


In step 4. you're asked to apply a filter to the year column. In step 5 you are asked to deselect (remove) 3 column. After step 6 you are asked to remove the year filter before continuing. the code above should let you continue with the exercises.


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 8 guests