Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Add column with average per category

  Hi,   I am a newbie at Powerbi. I want to have the average price per category. But I don´t want to create a measure, as for me it has to be a fixed table. I manage to create a Measure, but then...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Try this calculated column formula

    Average_Price = calculate(average(Data[Price]),filter(Data,Data[category]=earlier(Data[category])))

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

Try this calculated column formula

Average_Price = calculate(average(Data[Price]),filter(Data,Data[category]=earlier(Data[category])))

Hope this helps.