Forum Discussion

Keithr197's avatar
Keithr197
Regular Visitor
2 years ago

Calculating growth rate as a measure

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!

Need Help

1 Reply

  • ronrsnfld's avatar
    ronrsnfld
    Icon for Super User rankSuper User
    2 years ago

    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?