I have 24 months of data and change this every month.
Currently the range is 01.07.2019 - 30.06.2021.
I have the reports I want in excel and trying to recreate them in Power BI - this is useful as I can sense check them.
I have tried to use the attached formula that was from a previous post from Melissa
This does not give me the answer I am expecting. I have used the date tables provided by Enterprise DNA so know these are OK.
Once I have this resolved is it possible to then have a formula for the prior R12 month… I guess this must be easy.
I am really finding the shift from Excel to POWER BI incredibly difficult but feel it is really worth the pain - DAX feels like a completely different thing to excel formula and despite being pretty good in excel I feel like an amoeba in Power BI
Hi @NeilR, I noticed you didn’t provide a PBIX file. Providing one will help users and experts find a solution to your inquiry faster and better.
A perfect initial question includes all of the following:
A clear explanation of the problem you are experiencing
A mockup of the results you want to achieve
Your current work-in-progress PBIX file
Your underlying data file (to allow us to go into Power Query if necessary to transform your data and/or data model – often DAX questions really end up being data modeling solutions)
I think you will appreciate the Accelerator that’s currently being hosted by @BrianJ on eDNA. This weeks round ( #3 ) will probably shet some light on why and how things work in DAX. If you haven’t joined in this initiative, I highly recommend it.
. You can also revisit previous rounds, solution video’s and other content are here in the portal.
I wholeheartedly endorse Melissa’s recommendation of Power BI Accelerator as an initiative that will definitely help you build up your DAX skills and understanding.
Two other suggestions:
DAX Studio (one of the essential External Tools for Power BI) recently added a feature called Query Builder, which lets you build out DAX queries interactively. Even better, there’s a window at the bottom of the screen that visualizes the result of your query. I find this window into visualizing what DAX is doing in real time is invaluable in developing a strong understanding of DAX. Here’s a recent introduction that SQLBI did into the Query Builder function, plus a recent GIAC video on the same topic:
Also, here’s a video I did a while back on strategies for improving your DAX skill that I think you might find helpful:
And here’s Patrick from GIAC’s strategy on learning DAX:
Finally, I would just encourage you to “keep pounding the rock”. Progress on DAX is not linear. Instead, it often looks like no progress, no progress, no progress, then BAM! - lightbulb clicks on and you make a huge leap forward. Then back to no progress, no progess, and the BAM! again. By applying some of the techniques above and speeding your progress with Power BI Accelerator, you will still have those plateau periods, but they will become shorter and shorter over time.
Indeed. One caveat - DAX Studio is an incredibly powerful tool with a lot of complex capabilities. At this point in your learning process, don’t worry about learning that other functionality - much of it has to do with optimizing DAX and your data model. I’m a firm believer in “make it work, THEN make it fast”. At this point, you’re just at the “make it work” phase. The DAX Query Builder will be the primary reason you’d be using DAX Studio for now.
For the future, just note that we have some excellent tools and techniques available for free to members and nonmembers that you can use to mask any confidential data in your PBIX so that it can be posted to the forum with no concerns.