[rhinofromTurkeyParticipant Started: 0Replies: 7Total: 7]

I used the sheet at home and the issue I have at work is the RANKX function is not available on v1 – which would make this a non-issue.

So my issue really is a non-issue… if I had the correct version of PowerPivot – thanks for your help

 

The “real world” examples I have to deal with make learning PowerPivot more exciting, since I get to see how far I can take the product and how to introduce new things I read about on the blog.

Thanks again

Rhino

[rhinofromTurkeyParticipant Started: 0Replies: 7Total: 7]

I have to upgrade my powerpivot version… :-/  – might be why I dont have the full functionality/feature-set

I’ll report back  (see how IT long IT admins take)…

Thank you for your time and effort

 

I took the 2 day course and I signed up for the 1 year membership to PPU… I’m learning something else now and will be getting to the PPU shortly.

I’m not sure which one you’re referring to?

[rhinofromTurkeyParticipant Started: 0Replies: 7Total: 7]

Tomallen:

Just wanted to say thanks for all your help – again.  I really do appreciate your time.

After going through all the calendar posts, and how they said having a calendar table would make things easier – I ended up making my own calendar along with a column that matched my Login_Date field.  I then created a relationship for the two tables (new calendar field and login_date) and then placed the slicers in the excel file.

This might be excessive??!? but I’m getting the information I want and it’s displaying the Month Name (vs Month Number) which is GREAT.

And yes I believe you are correct about the date being being imported as Text from the SQL server which is what was causing the issue – although it doesn’t make sense as to why the Month number would be generated with the formula and not the Month Name.  Either way it’s good –

Thanks again

RhinoFromTurkey

 

[rhinofromTurkeyParticipant Started: 0Replies: 7Total: 7]

tomallen:

Thank you again for your prompt response

When I use =FORMAT(Stats[Login_Date],”MMM”) I get the same value as the Login_Date table

I did find a work around; however, I’m not so sure how to import it into the PowerPivot Designer

If I use in the Excel window in a Column I create:

=Text([Login_Date],”MMM”)

This gives me the correct month – not sure  if its as effective but its giving me the result.

What are your thoughts/professional opinion?  Should I use excel or should I use powerpivot?

Thanks

[rhinofromTurkeyParticipant Started: 0Replies: 7Total: 7]

tomallen:

my apologies i meant to add the = on the original post

Thank you for your reply; however, I’m unsure how your formula is working????

When I type =MONTH[Login_Date]  – I get an #ERROR and when I select Show Error it states – Cannot find table “MONTH”

I get the same error when I type =FORMAT(MONTH[Login_Date],”MMM”)

Am I doing something incorrect?

Thanks for your assistance

rhinofromturkey

 

[rhinofromTurkeyParticipant Started: 0Replies: 7Total: 7]

I believe after reading the two articles – I need a date/calendar table to cross reference/connect

 

http://www.powerpivotpro.com/2014/02/the-ultimate-date-tablerevisited/

http://www.powerpivotpro.com/2011/11/the-ultimate-date-table/

 

Thoughts?

 

[rhinofromTurkeyParticipant Started: 0Replies: 7Total: 7]

TomAllen:

Thank you very much for the reply –

The answer to question 2 is kind of what I was looking for, I’ll have to better prepare the question and then I’ll get back to you. However, it did shed some light on a different topic which will be helpful in the future – so thank you for that but of information you added.

rhinofromturkey

[Author]

Posts