Calculating growth rate as a measure

[Keithr197]

Hi everyone, I have a table that contains: Country, week, sales indicator, Sales issued, and year.

and I want to calculate the growth for country by week The formula I usually use (F2024/F2023)-1. Im having trouble writting this as a measure in power query to solve my problem. Any other way I can do this?

Can anyone help me with it? Thanks!

[ronrsnfld]

Please clarify your  question:

• Power Query does not have "measures". Do you mean to use DAX in Power BI, or M in Power Query
• You show only a single pair of "Country" entries ("Digital") but that refers to two different weeks.
  • How would you calculate growth for country for week in that instance?
  • Given the data you have posted, what would your expected results be?