Help

[Anonymous]

Hello! I am trying to move some charts over from Excel to PowerBI. I am trying to make a calculation where i would do (2020-Q1)/(2019-Q1) and this simple task is stumping me in powerBI. 

In Excel, I have my table of data for the quarters/years and the bookings data for each quarter. And so to do this, I would just reference each cell to do simple division and subtraction. But I can't figure out how to do this in powerBI and "reference" those specific things to make an automated measure for this. The things I would be dividing are both from the same field and I am not sure how I can choose to specifically divide by the quarter from one year before. Not sure if this makes too much sense, but would appreciate any help or insight with this! Thank you!

[Seanan]

Hi @Anonymous 

Would you be able to provide some example data or your PBIX file removing any sensitive data?