I Think I’m In SwitzerlandDecember 7, 2010
Here’s a picture JUST taken out our bedroom window:
So beautiful !! 60+ cms in the last two days with more to come (and then rain on Friday darn it )
So we have School Snow Days and extra neighbour kids and dogs and no plumbers (unfortunately).
So I have been hunkered down in my office (such as it is right now) working on DAX and working on Excel Tables and Structured references while trying to keep others at bay.
I have to admit that I am having trouble with DAX after years and years of straight Transactional data with SQL and with Excel formulas. I am finding it a lot easier to leave my data in Excel or in external relational tables and then manipulating the results in Excel Query and Pivot Tables.
The problem is not DAX though … the problem is ME. I have yet to find that magic point where DAX suddenly makes sense… that “Eureka” moment where it all makes sense.
I am able to get a lot of value out of CUBE functions as I have blogged about before but DAX still stays a mystery to me. When I get that breakthrough (and I will) I will bolg it here and everywhere because I believe in DAX and PowerPivot and want to see more people getting the most value from it.
Dick (disappearing into the snow)