Category Archives: Grab Bag

PUG Summit | Understanding Time Intelligence with Power BI

Presenter: Dan Edwards

Auto Date Fields

Power BI can create automatic date hierarchies, for report and drill down by Year/Quarter/Month/Day. It’s important to consider whether your data model has more than one fact table with a date attribute. If there are multiple facts, or you have already created a date table, it’s a better to use your own date dimension.

“Don’t use auto date/time” -Dan

I love these types of tips and tricks – here’s how it works, and don’t do it!

Creating a Date Table with DAX

It’s possible to use a DAX expression to create a date table. The initial DAX expression looks like this:

Date = CALENDAR(“1/1/2016”, “12/31/2019”)

Use the DAX expression to create a New table in Power BI.

2018-10-17_14-50-22.jpg

Then additional columns can be added to the Date dimension table:

Month = MONTH(‘DATE'[Date])

2018-10-17_14-53-35.jpg

It’s also possible to do concepts like MonthDate where you calculate a Date column with the first day of every month, which can provide flexibility.

MonthDate = DATE( YEAR(‘DATE'[Date]) , MONTH(‘DATE'[Date]) , 1 )

2018-10-17_15-04-02.jpg

Using an Effective Date

One of the scenarios is a scenario where the user wants to pick the effective date – for example a cutoff date or the last 12 months.

Dan mentioned he has a fairly extensive blog post on how to implement this concept.

 

Great presentation!

MVPs at User Group Summit

Looking for some fantastic sessions? Check these out – all led by a Microsoft MVP.

D365UG & AXUG Community General Session & Microsoft Town Hall

MVP Kelly Kane! She’s in charge! #womenindynamics

Kelly Kane @kellylappkane | Tuesday, October 16 | 8:15 AM – 9:15 AM | North Building, North Ballroom

BI12 – Moving From Reports to Business Intelligence

Who, me?

Joel Leichty @joelleichty | Tuesday October 16 | 9:45 AM – 10:45 AM | 122A – North

FIN17 – Understanding Production Cost Accounting for the Best Outcome

Don Riggs @donriggs_mvp | Tuesday, October 16 | 9:45 AM – 10:45 AM | 126B – North

HOL1 – Hands-on Lab: Workflow Part 1-Planning the Perfect Workflow

Rachel forced me to write this post. #UnderDuress

Rachel Profitt @rachelprofitt | Tuesday, October 16 | 9:45 AM – 10:45 AM | 127C – North

HOL2 – Hands-on Lab: Workflow Part 2-Making the Perfect Workflow Even More Perfect

Is there a part 3: “Making the Perfectest Workflow Go to 11”?

Rachel Profitt @rachelprofitt | Tuesday, October 16 | 11:00 AM – 12:00 PM | 127C – North

BI14 – Collecting BI Requirements for an Upgrade or Implementation

Joel Leichty @joelleichty | Tuesday, October 16 | 1:15 PM – 2:15 PM | 122A – North

FIN13 – The New Vendor Invoice Automation in Practice

I’m disappointed I can’t make this session! Looks great.

Ludwig Reinhard @dynamicsaxfico | Tuesday, October 16 | 1:15 PM – 2:15 PM | 125A – North

HOL3 – Hands-on Lab: Workflow Part 3-Finalizing and Testing the Perfect Workflow

LOL I swear I didn’t see this before I wrote my snarky comment above.

Rachel Profitt @rachelprofitt | Tuesday, October 16 | 1:15 PM – 2:15 PM | 127C – North

IND13 – Application Lifecycle Management: Operating Multiple Instances of AX 2012 R3 and D365

Thomas Ejby @powerpappi | Tuesday, October 16 | 1:15 PM – 2:15 PM | 126A – North

SYS07 – Leveraging Excel for Reporting and Data Manipulation

Excel!!! Best ERP on the market, in my opinion.

Justin Carter @DAXDude | Wednesday, October 17 | 2:30 PM – 3:30 PM | 121A – North

LPD04 – From Developer to Leader: What I Learned on my Journey Through the ERP Industry

Justin Carter @DAXDude | Wednesday, October 17 | 3:45 PM – 4:45 PM | 128B – North

LPD05 – The Art of Mentoring a Technical Expert

Don Riggs @donriggs_mvp | Thursday, October 18 | 8:30 AM – 9:30 AM | 128B – North

DEV09 – Flowing With the Common Data Services – Part 1

Rachel Profitt @rachelprofitt | Thursday, October 18 | 9:45 AM – 10:45 AM  & 1:15 PM – 2:15 PM | 122C – North

MFG09 – Ask the Experts: Master Planning

Don Riggs @donriggs_mvp | Thursday, October 18 | 9:45 AM – 10:45 AM | 126B – North

FIN18 – Understanding Revenue and Cost: Inventory and Purchasing Cost Accounting

Don Riggs @donriggs_mvp | Thursday, October 18 | 2:30 PM – 3:30 PM | 128A – North

FIN21 – Not to Fear: Audits, AX, and Beer is Back Again for 2018!

Our fearless leader is back!

Kelly Kane @kellylappkane | Thursday, October 18 | 2:30 PM – 3:30 PM  | 227A – North

POWDC08 – Power BI for Accountants

Belinda will teach you about debits and credits. Most accountants only dive into one other the other.

Belinda Allen @belindathegpcsi | Thursday, October 18 | 2:30 PM – 3:30 PM | 228B – North

D365UG/AXUG Closing Feedback Session

 

 

SAGlobal at AXUG Summit

I wanted to highlight some of my partners in crime presenting at AXUG/D365UG Summit next week. (Ok to be honest I wanted to highlight myself as well.)

BI12 | Moving From Reports to Business Intelligence

I won’t take Excel away until you’re ready. Promise.

https://www.eventscribe.com/2018/Summit/fsPopup.asp?embedded=true&pfp=FullD365UG_AXUG&Mode=presInfo&PresentationID=423650

Joel Leichty | Tuesday, October 16 | 9:45 AM – 10:45 AM | 122A – North

FIN01 | Fixed Price Projects, and Revenue Recognition, and Currencies, Oh My!

Josh is juggling in the session picture – I can only assume he will do this entire session while juggling flaming knives.

https://www.eventscribe.com/2018/Summit/fsPopup.asp?embedded=true&pfp=FullD365UG_AXUG&Mode=presInfo&PresentationID=423657

Josh Knox | Tuesday, October 16 | 9:45 AM – 10:45 AM | 121C – North

PM01 | Data Migration: Isn’t it Just Exporting and Importing?

Sherry won a big AXUG award last year, so I’ll retitle this session “Award Winning Data Migration Information”.

https://www.eventscribe.com/2018/Summit/fsPopup.asp?embedded=true&pfp=FullD365UG_AXUG&Mode=presInfo&PresentationID=423645

Sherry Moran | Tuesday, October 16 | 9:45 AM – 10:45 AM | 121A – North

BI14 | Collecting BI Requirements for an Upgrade or Implementation

I’m co-presenting with Gina Pabalan on this presentation. Fun fact: Gina and I didn’t know each other until we started collaborating for this session. That’s my favorite part of AXUG!

https://www.eventscribe.com/2018/Summit/fsPopup.asp?embedded=true&pfp=FullD365UG_AXUG&Mode=presInfo&PresentationID=423684

Joel Leichty and Gina Pabalan (Edgerwater Fullscope) | Tuesday, October 16 | 1:15 PM – 2:15 PM | 122A – North

FIN03 | Everything About Streamlining Your Project Intercompany Transactions

Should be a good one. And how many presenters do you know that can rock orange pants?

https://www.eventscribe.com/2018/Summit/fsPopup.asp?embedded=true&pfp=FullD365UG_AXUG&Mode=presInfo&PresentationID=423671

Alex Song | Tuesday, October 16 | 1:15 PM – 2:15 PM | 121C – North

APS33 | SAGlobal “Ask Us Anything”

Come to our Partner Showcase where we promise to not sell you anything! Bring your questions, we’ll have experts on hand to answer anything: F&O, AX, CRM, Talent, Power BI, baking at higher altitudes, average airspeed of unladen swallows – we’ll do our best!

https://www.eventscribe.com/2018/Summit/fsPopup.asp?embedded=true&pfp=FullD365UG_AXUG&Mode=presInfo&PresentationID=424349

Wednesday, October 17 | 10:00 AM – 11:00 AM | 125A – North

IND02 | Member Showcase: Implementing Dynamics 365 for Talent

See how our customer, M3, is using Talent.

https://www.eventscribe.com/2018/Summit/fsPopup.asp?embedded=true&pfp=FullD365UG_AXUG&Mode=presInfo&PresentationID=423713

Nancy Graver and Trish Mallon (M3) | Wednesday, October 17 | 11:15 AM – 12:15 PM | 126A – North

IND03 | Project Budgeting for the Service and AEC Industries

Budget your time wisely (#dadjokes) and attend Steve’s project budgeting session.

https://www.eventscribe.com/2018/Summit/fsPopup.asp?embedded=true&pfp=FullD365UG_AXUG&Mode=presInfo&PresentationID=423724

Steve Dobbs | Wednesday, October 17 | 2:30 PM – 3:30 PM | 126A – North

AXUG Session | Agile Methodology

I was thrilled to see this session on the AXUG Summit docket. An somewhat agile ERP implementation is generally what will end up happening, because it’s incredibly hard for users to Design an entire system before they are deep into system functionality. Planning a project broken down in smaller chunks helps keep projects flowing and provides a solution better suited to native functionality. 

Jennifer (the presenter) had an interesting way of describing Agile (frequent go-lives) and Hybrid (multiple sprints). A hybrid concept breaks down subsets of functionality and development into multiple short phases, then brings all functionality live at the same time.


One of the drawbacks mentioned was an agile approach requires strong project management skills to deliver. There are a lot of workstreams (Business process, Development, Data migration, etc) the project manager has to align from a timing perspective. Also, end users may not be used to an agile approach, so more methodology explanation is required on the front end of the project.


Excellent session – I agree a Hybrid implementation approach is the best default implementation option. This style of implementation moves the project forward quickly, while giving users a chance to revise and hone their system processes.


Presenter: Jennifer Johnson | @JenJohnson365

Dynamics AX Manuals is Now JoelLeichty.com

I felt annoyed for the past year that AX is no longer called AX, and I no longer make manuals for the iPad; “Dynamics AX Manuals” needed a refresh. Unlike product names, which seem to change every six months, I will very likely never change my name. With consistency and future-proofing as my guide, I decided to get creative and go with joelleichty.com. Also find me on Twitter @joelleichty.

If you ever want to vent about marketing craziness, use the hashtag #MicrosoftBusinessSolutionsDynamicsAXapta365ForFinanceAndOperationsEnterpriseEdition.

More Great Content

Periodically I like to highlight other bloggers who are active in the D365O/AX community. 

Kelly Kane is a newly minted MVP who blogs over at AX Soup about a “hodgepodge” of AX relatated topics. No word on how a hodgepodge compares to a plethora or slew. Kelly also promotes Women In Dynamics 👍🏻👍🏻. 

Rachel Profitt and I go way back, having worked together on an AX 2.5 implementation in 2002! She blogs now at Dynamics 365 Lady. And apparently getting her autograph at a conference is a rite of passage.

So there you have it. Lots of free great content brought to you by a fun bunch of nerds. If you find any of our posts helpful, please comment and like the content – we all love getting feedback on what helps you. 

« Older Entries