I am happy to now have a membership to the site! I first started with PowerBI in July ‘18. Found Enterprise DNA on my first day and have been learning from Sam every since. Sam, you have taken me quite far.
Been having a lot of fun with it, but my strength lies with MSSQL and with that on VLDBs. I stumble around in Excel, so it has been quite a transition for me to using PBI.
When things start going tough for me with DAX or the dang case-sensitive M I revert back to SQL and then pull the data into my model. I want to stop that and really see where a deep understanding of DAX can take me. First go deep with DAX and then M is my plan.
I have picked up a contract for a global company and my first order of business is to daily track budget vs spend. I have 3 different data granularities: Daily Monthly Budget data (basically a daily transaction log of monthly contracts - contracts can stop and start any day of the month), daily publisher cost tables and MTD publisher cost tables. I have physical joins and logical joins. I have a Date table. I pull data in from, my love, MSSQL, postgresql, and next week I dig into scraping data off the web to handle all the different currencies.
At this point in time I believe I have read all the books on the market and I have taken my Dashboard to as far as my experience will allow me. I am now at a point where I must learn more about TREATAS and INTERSECT to handle the different granularities which means I need to nail down CONTEXT.
I am going to watch several more hours of training videos before posting for help. I have been stuck for days now. Cant sleep thinking of new ways to tackle some of my problems. The biggest challenge for me using DAX is handling my monthly budget daily transaction log, and how to ensure I am summing all the contracts over the month.
Really looking forward to learning more from everyone and soon enough being able to help others as well.