Forum Discussion
Average Calculated Column per month
Hi,
I created a days ball in court calculated column using the difference of two dates.
I am trying to create a measure to get the average per month.
Thank you!
PabloGiraldo do you still want to see the data by date and repeat the avg for each date of that month? if that is the case then add a column in your table for the month
Month = FORMAT ( Table[EndDate], "YYYY-MM" )and the following measure for avg
Avg = CALCULATE ( AVERAGE ( Table[Days] ), ALLEXCEPT ( Table, Table[Month] ) )Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
3 Replies
PabloGiraldo do you still want to see the data by date and repeat the avg for each date of that month? if that is the case then add a column in your table for the month
Month = FORMAT ( Table[EndDate], "YYYY-MM" )and the following measure for avg
Avg = CALCULATE ( AVERAGE ( Table[Days] ), ALLEXCEPT ( Table, Table[Month] ) )Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
PabloGiraldo what defines month? Based on the start date or end date?
end date
