Forum Discussion

mfinlay's avatar
mfinlay
Icon for Advocate II rankAdvocate II
5 years ago
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...
Need Help
  • richbenmintz's avatar
    richbenmintz
    5 years ago

    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

richbenmintz's avatar
richbenmintz
Icon for Resident Rockstar rankResident Rockstar
5 years ago

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

  • mfinlay's avatar
    mfinlay
    Icon for Advocate II rankAdvocate II
    5 years ago

    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.