I am trying to perform some R12 calculations.
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
Thanks for your consideration.