Forum Discussion
Solved
Prior year calculations based on two dates
Hi Power BI gurus, I have a measure that has two dates associated with it - a booking date and a shipping date. I can get prior year calculations easily for one date, using calculate and dateadd DA...
Hi mfinlay ,
You can fix your error, by changing your relationship between booking date and data to 1 -> Many and changing to one way.
Will review the formula next to try to get the correct result
Thanks for your suggestion - I'm afraid I worked from the bottom up and the other reply fixed my issue 🙂
mfinlay LOL! Mate, too good. Best thing about Power BI is that there's a lot of ways to achieve the outcome you're after. And I am pretty sure the richbenmintz approach was much quicker.