Calculate Value to GAP Price
Hi team, I need your help to calculate "GAP PRICE", this is divide the Price Value of one column value between the another value from same column A column has 2 values: "Company 1" and "Company 2" Each Product has an Unit Price in each Company GAP_Price Product 1 = Unit Price (product 1 in Company 1) / Unit Price (product 1 in Company 2)
Average per row, reseting on each month
Hello! First Post. I have data of my country's position on a ranking list. I need to determine the average of that position for each month separately. Currently im using: Promedio = CALCULATE( AVERAGE(PowerBI[Posición]); FILTER(PowerBI; PowerBI[Fecha].[Month]<=EARLIER(PowerBI[Fecha].[Month]) && PowerBI[Fecha].[Day]<=EARLIER(PowerBI[Fecha].[Day])) ) But the averages are wrongly calculated. I also noticed that on the first day of the month if position is 50 the average shows 55.5 which means its carrying values from the previous months. Please help me fix my formula. Thanks in advance.
