Forum Discussion
PROMEDIO CON CONDICION DE FECHA
Hi JANDRES
Regarding the average asset you want to calculate, here is the solution we offer:
Here's the dummy data
First, you'll need a calculated column to determine the start date (December of the previous year) for each row in the table
last date = DATE(YEAR([date])-1, 12, 1)Then, create a measure that calculates the average of the assets between the start date and the end date (current date or selected date).
avg_asset = CALCULATE(AVERAGE(Assets[asset]), FILTER(ALLSELECTED(Assets), [date] >= MAX([last date]) && [date] <= MAX([date])))Here is the result
Best Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi JANDRES
Regarding the average asset you want to calculate, here is the solution we offer:
Here's the dummy data
First, you'll need a calculated column to determine the start date (December of the previous year) for each row in the table
last date = DATE(YEAR([date])-1, 12, 1)
Then, create a measure that calculates the average of the assets between the start date and the end date (current date or selected date).
avg_asset = CALCULATE(AVERAGE(Assets[asset]),
FILTER(ALLSELECTED(Assets),
[date] >= MAX([last date]) && [date] <= MAX([date])))
Here is the result
Best Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hay alguna forma de calcular "asset", teniendo en cuenta que "asset" tiene otra columna con diferente divisiones?, por ejemplo:
date asset prod_asset
12/3/2022 1000 A 12/7/2022 3200 A 1/4/2023 5000 A 4/1/2023 4300 A 10/7/2023 7600 A 2/9/2024 6300 A 4/5/2024 7100 A 6/6/2024 5000 B 8/8/2024
1000 B
TOTAL_ASSET= SUM(ASSET)
asset = CALCULATE(TOTAL_ASSED, prod_asset="A")
