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
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
Ah, hadn't spotted that the test data had caused an incorrect join.
That has fixed my calculation, and the calculation appears to work as I'd hoped - thank you.
